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?
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.).