Keep duplicates - apply to all columns except


I have data coming in with the following structure, and with which I want to do duplicate checks:

  • 1 column will always be present (with the same header), and I don’t want to apply the “keep duplicates” to this column (it’s a unique ID)
  • “x” number of columns, which will vary in header, and I want to apply the “keep duplicates” to all these columns (so if they two rows share values in all these columns, then keep these two rows).

However, the way “Keep/Remove Duplicates” action is made at the moment, I can’t select which columns I don’t want to apply it to, so I can’t do a universal project that works with any columns that come.

Is there any other workaround that could help me achieve this at the moment?

Thanks very much!


1 Like