Skip to main content

I've created an action flow (pictured below) and have queried data based on an analysis I've built. When creating an analysis you have the option in the table for Distinct Values however obviously that's not an option in Action Flows. How can I ensure the data I'm pulling is only showing distinct values? image

I solved it. Write DISTINCT in front of the columns when querying the data in step 1

EX: DISTINCT(table.column)


Hi,

 

Additionally one of the options is:

1) changing data to array (Array agregator)

2) deduplicate module with that mapping (

obraz)

 

Best Regards,

Mateusz Dudek


Hi,

 

Additionally one of the options is:

1) changing data to array (Array agregator)

2) deduplicate module with that mapping (

obraz)

 

Best Regards,

Mateusz Dudek

Thank you I will try that next time!!


Reply