Check the existing value in data table column

Hi,

I have an excel sheet with two tabs. I need to check a value that existing in sheet1, if its not existing then need to verify the same value against sheet2.

converted the excel in to two different datatable for sheet1 and sheet2. Tried some solutions buts its not working.

Would be grateful if you help me on this.

Thanks,
Jose

go through the datatable using a for each row, then if row(x) = yourValue do your thing.

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

Hi niteckam,

your suggestion is working fine. Thanks for your help.

I tried like below,

Filter_DT = DTtable.select(“column='”+your value+“'”)

if((Filter_DT.count)=1)

Thanks,
Jose.

2 Likes