For Each row running non stop

Help Studio
, ,
#1

I have a flowchart with csv and for each row running continuously. The csv has only

1
11914Ă—882 15.7 KB
2 rows of data it should stop after 2 runs. How can i achieve it ?

2
21914Ă—882 24.9 KB

#2

Check the row count of docinformation2 … ? Seems empty records are getting looped from csv file

#3

The csv doc has only two rows. Is there anything else which i missed ? Can we set the run count in some fields ?

#4

If your csv files had records earlier and you deleted it by selecting the cells, this issue occurs.
To confirm this, Create a new sheet and copy only the first two rows that you want to loop to the new sheet. Delete the old sheet and rename the new sheet to required sheet name.

Now try executing the BOT.

1 Like
#5

@Aaditya, Use Write Line Activity with value dtVariable.Rows.Count.ToString, to confirm row count before For Each Row Activity.

Cheers

1 Like
#6

@Bhavik_Solanki Should i add this in flowchart before for each row ?

3
31914Ă—882 22.3 KB

#7

@Madhavi I tried, it didnt work.

#8

Is its possible to share the csv file?

#9

@Madhavi i am unable to attach the csv file. Its not supported

#10

Zip it and send

#11

New Compressed (zipped) Folder.zip (387 Bytes)

#12

@Aaditya, let me rephrase. Add Write Line Activity between Read Range Activity and For Each Row Activity with value “docinformation2.Rows.Count.ToString”. I assume docinformation2 DataTable variable is used to populate information from Read Range Activity.

#13

simple workaround

Use if condition in For each

Condition Not row(0).ToString.Equals("")

which checks the first column values of a row. If it is null Put a break and loop out

#14

Hi

I have tried with the File,you have provided and it is working fine :slight_smile:
Can you check the workflow which is attached along with this ?

If you are facing , the issue could be that there is a data in some other row.
You can doCtrl+down in the csv file and check.

Forforum.zip (13.6 KB)

#15

It is looping back to first row instead of 3rd empty row