I have a data table with 23 columns and I need to find duplicate rows. For each duplicate row I need to add a flag on both identical rows on a 24th column. Whats the best approach? I have been searching the forum but I only find examples comparing one or two columns. I need to check all 23 columns. Is it possible to treat the 23 columns as one string like “Column1,Column2,…” and compare this string to other rows?
What I’ve done so far is to sort the data table on an ID and added the 24th column. Now I would like create the big string and loop through the data table. No idea how to do this though or if there are better ways to do this,…