Group by columns based on duplicate records

Question

I have created a workflow using the Unique tool to separate duplicate records and then join them the original records. The problem is that all the duplicate records are now placed at the bottom of my excel output. To differentiate them I have created additional column with value true if record is duplicate

What I want is that the original and duplicate records of each instance occur together. So it will look like 1 original record followed by all their duplicate counterparts with true in the duplicate column and have this pattern throughout the output

Emil_Kos · Accepted Answer

Hi @fardeen9983,

You need to first sort the data by the column identifier if you have any and afterwards, at the same filter use a sort by column to show the original trade at the first place.

If you don't have a unique key sort the data by all columns used in the unique tool. It should do the job as well.