Way to drop duplicates for all columns

[wonka1234]

I am trying to find a way that will take into account all columns and delete rows that are duplicate in all these row?

I am using Unique , but I dont want to use this for all my columns.

is there a work around?

[Luke_C]

Hi @wonka1234 

I'm not sure I follow the question. The unique tool with all fields selected sounds like it should do the trick. Maybe an example would help?

[wonka1234]

sorry luke, my fault, i thought unique was only allowed on one column.

[Jonathan-Sherman]

Hi @wonka1234,

I'm assuming you're looking for a way to keep it dynamic if new columns come in? You could add a record ID and transpose the data to concatenate all values. Uniquing on that will tell you which Record ID's should be removed (as they are duplicates).

Input:

Workflow:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[wonka1234]

Sorry Jonathan - I mean a user interface input as an analytic app. The user to input multiple lines of numbers. Ie they input 1234, 4567, etc. and the filter is applied based on their input.

[Samanthaj_hughes]

If its just on the one column a unique should work from what you described. Perhaps attach your example and we can understand further if this is not working we can support debugging.