How to compare 2 differnt columns in 2 datatables

[thima (Himabindu)]

Hi guys,

I have one excel having “swc” column and one more excel with “noteClli” column i need to compare values from “swc” column to"noteClli" column.my problem is “swc” column contains only 3 values but “noteclli” column contains 151 values. I have taken for each loop and tried but its looping times, is there any other way to do this. Kindly suggest.

Thanks,
Hima

[AshwinS2 (Ashwin S)]

Hi @thima

Based on for each
Give equals condition in true you can give break activity

Thanks
Ashwin.S

[Palaniyappan (Palaniyappan P)]

@thima

ne more excel with “noteCl

Kindly try with LOOKUP DATATABLE activity

Activities - Lookup Data Table

Cheers @thima

[vikaskulhari]

Hi @thima, this is a frequently asked question so please spend sometime on the forum to find the answer before posting. Anyway please refer below link -

Check the existing value in data table column

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

or

you can use lookup datatable activity.

[thima (Himabindu)]

I tried lookup datatable its showing up null values and writing index as -1 can please share sample xaml file using lookup datatable activity