To check two datatable column has contains any word match

Dt1 - Emp
Jony whatson
john boss

Dt2 - Emp

Dt2.AsEnumerable().Any(Function(x) x(“Emp”).ToString.ToUpper.Contains( row(“Emp”).ToString.ToUpper)) in for each

i getting error because second datatable Dt2 column string values is small compared to Dt1
is there is any other way to match two of these column

you were almost done the expression be like this
Dt1.AsEnumerable().Any(Function(x) x(“Emp”).ToString.ToUpper.ToUpper.Contains( row(“Emp”).ToString.ToUpper))

so in FOR EACH ROW activity pass the variable DT2 as input

i have to check only Dt1 column values and Dt2 values are default ,then only i can find any excess column value while looping (ex:willen) in above given example

1 Like

Is the final expected output following:
return all rows from dt1 where dt1("EMP) has a case insensitive contains in dt2(“EMP”) ?

yup, is there is another way to match Dt2 with Dt1

yes there are options. just give me a few mins i will prepare a demo XAML for you

Then compare like this in your own expression
Dt2.AsEnumerable().Any(Function(x) row(“Emp”).ToString.ToUpper.Contains(x.Field(Of String)(“Emp”).ToString.ToUpper))

In a reverse way

Cheers @brindhaS

1 Like

ok thanks

Demo XAML here: brindhaS.xaml (8.1 KB)
Can you please quick check, thanks

its working now thank you so much

1 Like

thanks for quick reply

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