Getting except data in 2 datatable/array

[Sweety_Girl]

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

[Srini84 (Srinivas Kadamati)]

@Sweety_Girl

Check as below

UnMatched_Two_DataTables.xaml (9.4 KB)

Mark as solution if this helps

Thanks

[Sweety_Girl]

Can we do the same with 2 arrays?

[ppr (Peter Preuss)]

@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

[Sweety_Girl]

@Srini84 and @ppr Thank you

Both Works!!