Distinct Tool - Multiple fields
Options
MClark05
Registered Posts: 2 ✭✭✭
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?
Answers
-
Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭OptionsHi,
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.