"Select Distinct" not working in Studio version

Flow Classic
1

Hi,

I have a FlowScript code segment that works in our DEV Environment but doesn’t work in PROD. I think it is because the DEV version of Flow Studio is 6.14.13.8 and the PROD version of Flow Studio is 6.13.17.40064.

Is there a Workaround I can use?

The code is

let x = select distinct ln4, prt, loc from dupcnt6;

return x;

“Distinct” is not recognised in the version 13 (I think). I removed “Distinct” and tried “GroupBy”, it doesn’t work.

Select Distinct
Select Distinct746×480 10.8 KB

2

Hi,

this is how we used to do it back in them olden days… versions :slight_smile:

let x = empty(dupcnt6);

for item in dupcnt6{

if count(x where ln4&prt&loc = item.ln4&item.prt&item.loc) = 0 : set x = x & item;

}

return x;

image
image1878×819 43.9 KB

Hope this helps!

B R

Ivan

3

That worked, thank you very much!