Getting except data in 2 datatable/array

I have 2 datatable…

Table A has some rows and Table B has some rows…

Table B contains the rows which will be available in Table A…

I need to get the value of table B rows which are available in tableA

Eg:

Table A
Column 1
abc
cde

Table B
Column 1
cde
rfe

Output
rfe

@Sweety_Girl

Check as below

UnMatched_Two_DataTables.xaml (9.4 KB)

Mark as solution if this helps

Thanks

1 Like

Can we do the same with 2 arrays?

@Sweety_Girl
arr1.Intersect(arr2).toArray - getting the items which are common in both arrays
arr2.Except(arr1)toArray - getting the arr2-items which are not common with arr1

2 Likes

@ksrinu070184 and @ppr Thank you

Both Works!!

1 Like

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