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
27 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

Related Questions In RPA

0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16 in RPA by Venkat
• 320 points
2,108 views
0 votes
1 answer

How to assign a data in a variable in to excel file?

System -> File -> Workbook -> Append ...READ MORE

answered May 22, 2018 in RPA by wrecker
• 3,090 points
60 views
0 votes
3 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

1.  Excel Application Scope (Activity) : In ...READ MORE

answered Jun 9 in RPA by anonymous
• 140 points
2,080 views
0 votes
1 answer

Changing a specific column of an excel sheet in UiPath

You can use a For each row ...READ MORE

answered Jun 21, 2018 in RPA by Atul
• 5,530 points
171 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
36 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,090 points
165 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,090 points
140 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,090 points
254 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
59 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
29 views