in Education by
I'm learning AAE for like a week and I have problem with for loop in excel file. I have prepared table with Vendor Id, Material, and order Quantity: Vendor Material Quantity 25000 1545454 100 64003 7854786 1024 25000 5896471 250 25000 3336661 900 64003 7854786 2048 25000 3336691 900 And I wanted to validate the table if there is any redundancy in the material and vendor column. I have created 6 variable 2 for each column and named them: POv, POm, POq and Vpo, Mpo, Qpo. And of course 2 itterators Itteraor2 and Itterator3 that I am incremanting in 2 loops Problem is that my loop is infinite, while I wanted only to iterate 6 times (number of rows) and additionally it is messaging me that row 2 AND 3 have the same vendor ID and material ID what is not true. Could somebody tell me what is wrong and how to fix it? Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
There are a few corrections to be made in the code: 1)For the inner loop, consider placing the variable operation between End If and End Loop. Looking for RPA material from basics! Refer to this video on RPA provided by Intellipaat: 2) For the outer loop (before $iterator3$+1), ensure that the inner loop counter is set like this $iterator2$= $iterator3$+1 so that it does not compare the previous rows again.

Related questions

0 votes
    I'm learning AAE for like a week and I have problem with for loop in excel file. I have prepared table with ... and how to fix it? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    Does anyone know of an easy way to start an excel loop in Automation Anywhere at a row other than 1? (or ... work. Thanks in advance. Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I started running process and now I can't stop it. I can't start running any other process while the first ... this problem? Thanks! Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I have seen Microsoft Cognitive services such as text analytics and some other services. Here I have gone through ... much about it? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am writing a task in Automation Anywhere and would like it to break if a certain variable is set to "false" ... the code is executed? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am using AA for almost 6 months and I found that by default I am not able to see any lines/dotted lines/ ... to be set in properties? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I need help with Automation Anywhere I have the following Drop-Down List and need to select an option. < option ... "0002" Thank you. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I want to get a value from a particular location from list variable. Right now what I see is it only ... from a specified location? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    How can I change the user input date format in Automation Anywhere without changing the system variable format? Example: ... 05/28/2018 Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    Hello I tried to use MWC function in AAE to pick the correct position form drop-down menu but I am receiving ... supposed to look like. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am writing a task in Automation Anywhere and would like it to break if a certain variable is set to "false" ... the code is executed? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I am using AA for almost 6 months and I found that by default I am not able to see any lines/dotted lines/ ... to be set in properties? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I need help with Automation Anywhere I have the following Drop-Down List and need to select an option. < option ... "0002" Thank you. Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I want to get a value from a particular location from list variable. Right now what I see is it only ... from a specified location? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    How can I change the user input date format in Automation Anywhere without changing the system variable format? Example: ... 05/28/2018 Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
...