Submit your use case or success story to the 2023 edition of the Dataiku Frontrunner Awards ENTER YOUR SUBMISSION

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