Plz help me to solve the usecase

[katta_nikhil]

i have a n excel with coloumns of NO, NAME, COUNTER
if the counter has value of 5 … then we have to create the ouput xlsx file with 5 rows
how can do that

[Jithesh_R]

@katta_nikhil ,
Can you please share the sample Input File and the Output .

Regards,

[Palaniyappan (Forum Leader)]

Hi

Use a if condition like
Counter = 5
If true in then block then use a WHILE ACTIVITY with condition like this

Repeatcounter < counter
Where Repearcounter is a variable of type int32 with default value as 0 defined in variable panel

Inside the loop use a
ADD DATAROW activity like this to add a empty row

And use a assign activity like this to incremental the repeat counter value

Repeatcounter = Repeatcounter + 1

Cheers @katta_nikhil

[katta_nikhil]

sure
output.xlsx (10.9 KB)
testdata.xlsx (8.4 KB)

[Jithesh_R]

Hey @katta_nikhil ,
Please check this workflow

Counter.zip (2.4 KB)

Output :

Regards,

[katta_nikhil]

thankyou i can modify this