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!