Check if a variable exists in an Excel file

Help Orchestrator
1

Hello everybody,
How can we check if a variable exists in an Excel file?
My excel file is made up of two columns. So the robot must check if my variable exists in the first column. If it has found it it extracts its equivalent from the second column.

2

Like this:

Processusvierge.zip (8,6 Ko)

3

I had an error in the assign activity: cannot find column (Column 1)

4

You have to replace the “Column1” text with the header from your own Excel file. The process works as-is with the given Excel file, but you’ll need to adapt it to your needs.

1 Like
5

Precisely I tried with your Excel file to see the operation but I got this error message. I will adapt it to my process. Thank you.