Vlookup in Datatable - check a value is present in another datatable

Help
1

Need help

I have two datatables. DT1 & DT2 . want to perform a vlookup .

from DT1 a value needs to be searched in DT2 when found, retrieve adjacent value or the row index of value found

Thanks

2

@armamidwar Bro you can use two For Each Row Activity.

Put one into another. Take DT1 value and take DT2 value by Get Row Item. Use the IF Condition to check the first value is Equal to 2nd value. If match you can retrieve those values you want.

TanQ,
Michael Udhaya

1 Like
3

Hi Mic, thanks again.

want to return a Boolean value . if present then yes or else no .

Thanks ,

Anil

4

@armamidwar Bro, you can use Assign Activity to set the Boolean value to True or False. Put the True assistant if you got that value(in the then block in If condition) and break that loop. Other set the False value in the else block.

Ask me if any doubt!

TanQ,
Michael Udhaya

5

@Michael_Udhaya could you elaborate on how to do the above ?