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, 2019 in RPA by DareDev
• 6,890 points
5,533 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, 2019 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

How to extract table and text from pdf file and load into Excel by using workbench commands in automation anywhere

Hey Dhruv, to extract table and text ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 28,100 points
3,065 views
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, 2019 in RPA by Abha
• 28,100 points
3,202 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 17, 2019 in RPA by Abha
• 28,100 points
5,099 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, 2019 in RPA by Abha
• 28,100 points
1,192 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, 2019 in RPA by Iffath
• 1,180 points
1,824 views
0 votes
0 answers

Which version of Automation anywhere is more used now in organizations AA2019 or AA2011 ?

Which version of Automation anywhere is more ...READ MORE

Nov 18, 2020 in RPA by anonymous
• 140 points
269 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
679 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
981 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, 2019 in RPA by Iffath
• 560 points
1,316 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, 2019 in RPA by Iffath
• 560 points
219 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP