How to skip the duplicate rows by selecting only its first occurance?

[Vinodraj_N]

Hi…

I Have a datatable shown below

        candidateNo

row1: 1234
row2: 1234
row3: 1234
row4: 7895
row5: 7895

Here, i need to select only the row of first occurance of Candidate number and fetch the entire row, then jump to the next unique candidate number…

for example, Candidateno = 1234, which is repeated 3 times but i need to fetch only Row1 and then jump to next Candidateno =7895,which is row4, so on

Can any1 help me with this?

[Dave (David Wiebelhaus)]

How to remove rows with duplicate columns

Hello @carlor you can use linq here use this code in an Assign Activity (From roww In DT.AsEnumerable() Group By id=New With {key .i=roww.item("col1"),key .d=roww.item("col2")} Into gg=Group Select gg(0)).copytodatatable it’ll group the two columns in your case col1 and col2 the workflow should look like this [Group%20by%20calor]

[ppr (Peter)]

Copy duplicated rows of a datatable into another datatable

@NazAutomate find some starter help here: FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB) In case of empty search results a re to expect, then save it up before like: [HandleEmptyReturnedResult_CopyToDT]

In Case of the datatable inly have 1 datacolumn following Statement can be Used as Well

Yourdatatablevar.defaultview.totable(true, {“yourcolumnname”})

[Vinodraj_N]

HI @ppr

I have many columns corresponding to unique candidateno,

I dont want to copy the result to new table, i mean i dont need a new table, i just want to find the indexof first occurance of the Unique id and then move to next unique id in a for each row…

[Dave (David Wiebelhaus)]

Why does it matter if you use a new datatable with the duplicate rows removed, or if you use the existing datatable and skip duplicate rows? The end result is exactly the same, but it’s much easier programmatically to just create a new datatable variable than it is to code something that skips over rows on your existing table. New datatable is quicker to code, easier to read/understand, and will be faster to process

[ToddPull (Todd)]

Just use a for each row loop, capture the value of the index in a variable, and use an if statement that compares the current index to the variable; if they are equal then X else Y

[NIVED_NAMBIAR (NIVED N)]

Hi @Vinodraj_N

You can try this

BlankProcess2.zip (39.4 KB)

Hope it helps

Regards

Nived N

Happy Automation

[Vinodraj_N]

Hi @NIVED_NAMBIAR

Thanks Your Replay, I also tried the lookup datatable but got stuck…

You provided me Exactly what i was Expecting.