Same data-table compare

Hi,

I am having an following doubt/requirement.

  1. A datatable with following column names as “sno”, “Name”, “ID”, “Place”
  2. So, there will be duplicate “ID’s” in the same data table.
  3. I want to compare with the same datatable and get duplicate list as separate datatable and non-duplicate as seperate datatable.

@Palaniyappan

1 Like

@monish06
To get the unique data by avoiding the rows by duplicate id you cae use the assign activity as in the screenShot shared.

testDT is the datatable with data and the tempDT is used to store the filtered data.

How can i get the list of duplicate values as separate DT and unduplicate values as seperate DT.

1 Like

Did this thread help buddy

Cheers @monish06

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.