Remove duplicates in a single row

[aly]

hi i want to remove duplicates in a single row by comparing multiple columns

I want to keep one of each eg if there are 3 (PDF) in a row, 1 (PDF) will remain in table. how can i do this?

[Lahiru.Fernando]

Hi @aly

You can loop through the columns and find the duplicate values…

For example:
For each row
Inside:

Do another for each DT.Columns
Save value of the current column in a variable
Then loop through the columns of the row and compare with the current value.
If a match is found, replace it with a empty string.

Hope this helps

Let me know if it is not clear

[aly]

hi may i have a sample of how i can do this? still don’t quite understand