Checking if one data from an excel matches another , then getting the crossponding value

Datatable->Dt1
Datatable->D2
User for each row activity ->Dt1

use IF activity
Dt2.Select("column1= '"+row("column1").Tostring()+"'").length>0

If value returns true then the value exists in the 2nd table

Regards,
Arivu

1 Like