Compare two datatables and get unique value from dt1

Help Activities
1

Hi,

I am facing one problem,

I have two dt
dt1 -
ID
1
2
3
4
dt2-
ID
4
5
6

I just want rows present in dt1 but not in dt2.

2

Hey @Sahil_Garg1

Left join using Join Data Table activity would be a good option to go with.

Thanks
#nK

3

dt1.asEnumerable.Except(dt2.AsEnumerable, DataRowComparer.Default).CopyToDataTable

2 Likes
4

Hello @Sahil_Garg1

The below expression will give you the result.

DT1 and DT2 are the 2 datatables.

image
image821×82 29.5 KB

1 Like
5

can share one test flow

6

@Sahil_Garg1

Plz watch the below video…If you want both similar you can use Intersect and only rows from Dt1 then use Except.

7

In case that an empty result is also to expect the copytodatatable can be defensive handled as described here:

:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

1 Like
8

It is return no rows,

9

It is giving incorrect result as i want 1,2,3 but it is including 4 also

10

is data exact as the 1 column structure data from the description above or is another dataset is used e.g. with more columns?. Can you show the used test data?

11

Test.xlsx (9.0 KB)
Yes, only 1 col is there ID

12

find some demo / starter help here:
DataTable_SetOperations.xaml (8.9 KB)

kindly note: Except / set operation operators are using the entire row for the check (so 2,n cols were also working with the same command).

We will soon run it with your data

1 Like
13

Hi @Sahil_Garg1,

When I check it it gives correct result.

Test.xaml (5.6 KB)

Regards,
MY

14

it was working, can you please share some details of your implementation? Thanks

15

Buddy,

I test data which i shared with u, i want out of rows 1…25, which are unique in dt1.

I have done it through loops and complex conditions but just looking if any query can do it to make it faster

16

grafik
grafik859×602 79.8 KB

17

Main.xaml (5.9 KB)

19

my bad, just doing one silly mistake got it now.

Thanks everyone for quick responses

20

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