how to use lookup in uipath by starting 2 characters specified from each row
Can you please provide more info on this? lookup where using 2 characters? In DT or list?
I have excel rows with the data like
So i want to lookup data with starting 2 characters like in the first case “NC”
- Read the excel using “Read Range” and store the results in DT.
- Iterate the DT using For each row, get the value of the column by row(“columnName”).ToString.
- check if the string.startswith your lookup string… in your case its String.startswith(“NC”).
If yes, it will return the boolean value “True” and you can proceed with your next actions.
This will be iterating the entire variables in DT until you get the desired value (if its available).
Let me know if it helps. Cheers