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.
Based on for each
Give equals condition in true you can give break activity
Kindly try with LOOKUP DATATABLE activity
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
@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 -
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
you can use lookup datatable activity.
I tried lookup datatable its showing up null values and writing index as -1 can please share sample xaml file using lookup datatable activity