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?
Page 1 / 1
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 (
)
Best Regards,
Mateusz Dudek
Hi,
Additionally one of the options is:
1) changing data to array (Array agregator)
2) deduplicate module with that mapping (
)
Best Regards,
Mateusz Dudek
Thank you I will try that next time!!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.