Check the existing value in data table column

Help
3

Hello,

I suggest to convert both sheets into separate datatable: “DT1” and “DT2”
Use twice activity Output data table where: Input will be “DT1” or “DT2” and Output “DT1text” or “DT2text”
And you can use IF conditions to check if your value exist in first or second sheet
DT1text.ToString.Contains(“yourvalue”)
or
DT2text.ToString.Contains(“yourvalue”)

Thx