To check two datatable column has contains any word match

Help
, ,
1

Dt1 - Emp
Jony whatson
willen
john boss

Dt2 - Emp
Jony
John

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

2

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
@brindhaS

3

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
4

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

5

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

6

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

7

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
8

ok thanks

9

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

10

its working now thank you so much

1 Like
11

thanks for quick reply

12

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