How to stop Iteration in excel

Help Studio
, ,
1

I have 5 input pdf files so after execution one file data is Iterating 3-4 times,can anyone please help me on this to resolve the issue.find the attached below screenshot.

image
image979×212 4.26 KB

2

@Chippy_Kolot

Use the break activity in the iteration

Hope it works!!

3

Hi @Chippy_Kolot

For the last files there is a same data in the last 4 rows. I think in this iteration this data is effecting the for each of files.

Could you more elaborate your query for better understanding.

Hope it helps!!

4

@Chippy_Kolot

Take A array variable FoderPath=Directory.GetFiles(“Path”,“*.pdf”)
Build Datatable
Take For each loop

Use read pdf Text and the data is in a string variable
Use string manipulations and Regex to extract data
Use Add datarow activity

Outside For Each
Use write range activity

5

Hi @Chippy_Kolot - Can you explain a little brief. My understanding is after execution of pdf file is the excel loop is iterating for 3-4 times

Can you check how of rows of data getting extracted from the PDF. If the extracted data is 3-4 rows, then there is a chance the excel loop might iterate for multiple times to update those values to excel

6

Hi @Chippy_Kolot ,

Can you share 5input pdf file ?
I will test that
Regards,
LNV

7

Im having two sequence, Most of the input files will execute in the first one itself ,else we have to run it from second sequence. So if Im having 5 input files and 4 of them will execute properly from the first sequence, remaining 1 has to work from second sequence, so at that time it is iterating more times.

8

It is confidential, Im sorry I cant share.

9

@Chippy_Kolot

Please run your workflow in debug mode, So you understand why it will write data multiple times.
Take a look on for loop process

10

Hi @Chippy_Kolot ,
I tried with the folder containing the pdf file
You can try
my int/out
image
image
My solution

image
image415×675 21.9 KB

Regards,
LNV

11

@Chippy_Kolot - Can you please check below points

  • Please run the second sequence in debug mode and monitor closely
  • If possible, place the required message boxes in the excel loop of second sequence and see what is trying to write
  • Also, do you see any change in the output. What is the expected output and what is the output that you are getting