How to search a particular word from one datatable to another

Help Studio
, ,
1

I have datatable dt1

Col1 Col2
D_Cod 657

D_name Socket

D_Num MHFPP654

I want to search this col2 value one by one in another datatable dt2.

Please help I to search

2

Hi!

Try like this

read both the excels using read range output as dt1 and dt2

take 1 for each row mention dt1 and assign like this col2=Currentrow(“col2”).toString

take 1 more for each row mention dt2 and assign like this col3=Currentrow(“col2”).toString

take one if condition col2=col3

inside then your next requirement steps

Regards,
NaNi

3

Hi @Doonline

If you want to search a single value from one datatable to another you can use lookup datatable activity

Or else

You can proceed with the solution provided by @THIRU_NANI

Thanks
Robin

4

In Dt2 these words are not at one place,They are scattered somewhere in an datatable thats why i need to search col2 value one by one in another datatable

5

This is the way you have to do.

Regards,
NaNi

6

Hi @Doonline ,

Could you please let us know, What are the Steps after you have found the Matching Word? or What is the End Output that you Expect ?

This would help us to formulate the method needed to be used in the Suggested solution.

7

Hi @Doonline try using these methods:

–LINQ query: write linq compare query which compares two data tables .
–create 2 foreach activity and illiterate through two tables.

@THIRU_NANI method will work only for datatables having same data row at same column.