Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Distinct Tool - Multiple fields

Level 1
Distinct Tool - Multiple fields

I need to filter for unique rows, based on the criteria in multiple fields. I tried using the Distinct tool, but when I select "Find distinct values of a subset of columns" the output only includes those columns. I need the rest of my columns to come through the data set as well. Is there a way to accomplish this?

0 Kudos
1 Reply
Dataiker Alumni


You can use the Group recipe, identifying the key columns that will result in the distinct combinations. For the remaining columns, you use the aggregations section of the recipe to define their values (first, last, avg., etc.).

I hope this helps.

0 Kudos