Compare two rows in data table with multiple columns

Help
1

Hello folks i want to compare two rows in data table with multiple columns
if two or more rows are same i want to process only one row
ex:col1 col2 col3
aa 11 ss
aa 11 ss
bb

2

can any one help me thank you…

3

Hi @venkateshgorantla,

Here you can get the logic to compare 2 Datatables . The same manner you can do it the UiPath Studio.

Regards
Balamurugan.S

4

hey @balupad14 i am not comparing two tables, i am having data in single table

5

Try below code!

[datatablename].DefaultView.ToTable(True,“col1”,“col2”,“col3”)

1 Like
6

Thanks a lot @Vinutha its working fine thank you so much.

But one thing i want to now i am getting only three columns which i have mention in above code .
in my case i want all columns which are in datatable after applying this code .
awaiting reply.once again thank you very much.

7

If you are using 2018.3 or higher, there is an activity itself which removes duplicate rows.

image

8

I am not using latest version.
can you please help me if any you have any other idea…
thank you

9

You just have to specify all the columns as comma separated.

[datatablename].DefaultView.ToTable(True,“col1”,“col2”,“col3”,“col4”,“col5”, {etc})

2 Likes
10

thanks @Vinutha its working fine :smiley:

1 Like
11

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