Duplicates in FlowScript table

Flow Classic
1

Is it possible to find duplicates in a Flowscript table? I know how to do it in SQL:

select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;

Is there a Flowscript equivalent?

Thank you.

2

Are you looking for a list of the duplicates or just to remove them?

3

I want to find the duplicates. I actually figured it out. This link helped;

I will post the code when I have time.

4

I thought I only needed to see the duplicates but it turns out I need to remove them too.

I don’t know how to do that so any help would be appreciated.

5

Ok there are a few ways to do what you seem to be describing but each has different nuances based on exactly what you want to do.

For one thing you can do this to simply have your table with duplicates removed based on a list of columns.

let x = select distinct column-list from yourTable;

But maybe you want more columns than are included in the duplication? If so, how do you know which “other columns” you’d want?
Or maybe you don’t want the rows with duplication at all?

I’m not sure, a few examples or even a flow attached would help me help you.

7

Thanks for the reply but I only have one table with duplicates and I want to write a script that removes them.

I have uploaded a flow that loads the duplicates form a table into a grid

SampTable.flow (17.1 KB)

I need a script after the grid that removes the duplicates and enters them into a new grid. This image is what they should look like : Requiredresult hosted at ImgBB — ImgBB

Thank you for any replies

8

I think I got it, this worked (from wpuymac)

let x = select distinct column-list from yourTable;

Thank you also to Daniel for his reply

1 Like
9

yeah there are a few ways this could be done depending on what you needed to do from the starting to ending point. glad we could help!

1 Like