How to go through each cell in a datatable column and see if there is a duplicate value in a the same table somewhere

Help Studio
, ,
1

Hi, I merged two table tables and now I need help going through the values of a single column and finding if another cell has the same value in the same datatable.

2

Hi, you can use the remove duplicates activity if you need to remove them once merging

3

hi, i need to copy the row that includes the duplicate

4

Hi @m_R123

Could you please elaborate more. If possible please provide the sample input and the respective output (screenshots may also work)

5

Hello @m_R123

Please refer to the below video.

Thanks

1 Like