How to loop and write

Help Activities
, ,
21

here first some columns data is there and after doing some operation, will populate the data. Considering the last column I need to write case where number of rows

22

So it a static template with first column and you are adding data to it?

23

yes it is static template, but how many rows are there that should write attaching case

eg:2 rows then next should be Case2 in the first row of the 2 rows,
4 rows then it should be case4 in the first row of 4 rows.

you can find image above

24

Hi Sharanabasava1,
Use this workflow
Sample.xaml (10.5 KB)
FinalData.xlsx (9.3 KB)

I hope it will work for uou

Thanks,
Rounak

25

Hi,

image

it should write first consecutive of the rows and {10,6,7,8,9,3} it has written Case6 at number “9”

Thank you

26

and getting output like this for some of the inputs
image

I am attaching input file and in one column I have given expected output, how data is required
FinalData .xlsx (9.4 KB)

27

Hey!,

I finally understood your requirement :open_mouth:. But still the output will be displayed in the last row of the set as bot needs to read the continuous non empty rows and then only it can write it.

This the output you will get with this xaml:

image
Main.xaml (13.1 KB)

Regards,
Rajeswari

28

Thank you Rajeswari

29

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.