Using IF with Excel source data


#1

Hello. I have the excel file below.

A1

And I’m creating the RPA process below, loading the raw data into a “table” type variable.

A3

So, the question is: within a For-Each loop, how to use If-Then condition, checking if the 3rd column (Type), is equal to something?

Thanks!


#2

@trajano_leme

Hi Trajano,
You need to use two For Each loops in this case:
one to get a Row
the second one to get the value in the cell in the third column as shown in the screenshot below.


Then you can compare the value in the cell with your target value.

Alesia


#3

@ashapkina
Perfect! Thanks a lot! It works fine! Excellent solution.