Enumerable with 2 columns

excel
studio

#1

Hello!

I got this assign command on my workflow and I just cant figure out how to add here a second column. Now it only compares the datatables with the column “Name” and I want it to compare those with “Name” and “Phone number”.

Anyone have a good ideas what should be the proper way to add here the second column?

(From x In dt1.AsEnumerable() where (From a In dt1.AsEnumerable() Join b In dt2.AsEnumerable() On a(“Name”).ToString() Equals b(“Name”).ToString() select a).Contains(x) select x).CopyToDataTable()

Regards


#2

I’m not an expert, but does it let you use the AND operator?

(From x In dt1.AsEnumerable() where (From a In dt1.AsEnumerable() Join b In dt2.AsEnumerable() On a(“Name”).ToString() Equals b(“Name”).ToString() And a(“Phone Number”).ToString() Equals b(“Phone Number”).ToString() select a).Contains(x) select x).CopyToDataTable()


#3

Thank you!

I tried myself that And operator yesterday, but didn’t manage to use it right.
This works perfectly for me.

Regards
Timbozen