I have multiple excel files. I want the counter value should be back to 0, before reading the next excel file


#1

I have created a counter with 0 as initialised value. It increments as per the condition.
So this happens for 1 excel file.
It extracts date from excel loads it into the application and keeps the counter incrementing as it meets the condition.

Now I have multiple excel files. I want the counter value should be back to 0, before it starts reading the next excel file.

How do i achieve this?


#2

Hi @Mallika

Use Assign activity and assign 0 to your counter right after the loop:
image


#3

yeah i did the same. It worked…
thanks a lot


#4

There are one another way, you can initialize zero at your variable panel, there is no need to take a assign activity.