Looping through an Excel file in Automation Anywhere

0 votes

I have a loop issue in the Excel file. I've prepared a table with Vendor, Material and order Quantity as shown below:

Vendor Material Quantity
25000 1545454 100
64003 7854786 1024
25000 5896471 250
25000 3336661 900
64003 7854786 2048
25000 3336691 900

I wanted to validate the table if there is any redundancy in the material and vendor column. I have created 6 variables, 2 variables for each of the three columns. I have named them v1,m1,q1 and v2,m2,q2. I have also used 2 iterators- iterator1 and iterator2 whose value I am incrementing in two loops.

Here is the screenshot of what the code looks like:

This code is giving me an error, the loop runs for an infinite number of times. Can someone help me fix this?

 

 

Jul 9 in RPA by DareDev
• 6,810 points
903 views

1 answer to this question.

0 votes

Hi,

There are a few corrections to be made in the code:

1.) Use another iterator- iterator3 and set its value to 5

2.) Use your variable operations command outside the inner loop

3.) Loop through the file using iterator3 and decrement this value

4.) Use your variable operation command between if and end loop

For more details refer to the code below

I hope this helped..!!

answered Jul 9 by Iffath
• 560 points
Hi Iffath, thanks for sharing the answer. I was also facing the same problem, it really helped.

Related Questions In RPA

0 votes
1 answer
0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered Aug 19 in RPA by Abha
• 27,200 points
313 views
0 votes
1 answer

Which system variable can be used for reading data from CSV/text file in Automation Anywhere?

Hello, FileData Column(col_name) is the system variable which ...READ MORE

answered Oct 16 in RPA by Abha
• 27,200 points
106 views
0 votes
1 answer

Throwing an error while running bot through batch file in UiPath

Hello there, in your batch file, instead ...READ MORE

answered Oct 23 in RPA by Abha
• 27,200 points
16 views
0 votes
1 answer

What is the recommended way to open an application as part of a task in Automation Anywhere?

The recommended methods for opening an application ...READ MORE

answered Apr 1 in RPA by Iffath
• 1,180 points
239 views
0 votes
1 answer

UiPath - Citirx Automation

best way to do that is to ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
235 views
0 votes
1 answer

UiPath - Web Scraping

Multiple solutions are listed below: Check your Selector Use ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
269 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
362 views
+1 vote
1 answer

How do i share a session in Automation Anywhere?

You can create a hierarchy of TaskBot ...READ MORE

answered May 14 in RPA by Iffath
• 560 points
272 views
0 votes
1 answer

Can I get all the file names in a folder to perform some operation on

Yes, you can use the "Loop for ...READ MORE

answered May 10 in RPA by Iffath
• 560 points
45 views