Skip to main content
Question

How do you pull DISTINCT row values when querying a data model to create a CSV file?

  • October 11, 2022
  • 3 replies
  • 99 views

Forum|alt.badge.img

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

3 replies

Forum|alt.badge.img
  • Author
  • Level 1
  • October 11, 2022

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


Forum|alt.badge.img
  • Author
  • Level 1
  • October 12, 2022

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!!