How to write inside cell for more data for same iteration

Hi,

I am using for each row loop and inside for each row for each process i have to right log in one cell of excel.
for each process there are might be 1 or more than one project so for each project how can i write in same cell with comma saperator?
and after writing for this three/four project it has to go to next iteration.
so question is how can i write in same cell for more than 1 project ?
check this image it will write for first iteration for first project but will overide for second for same iteration.
1
how can i achieve this as below ?
2
Now i am using write cell to write like this.
3

Kindly help me for the same.

Hi @Mathkar_kunal,

Please try to store the existing cell value (at any time) within a variable.
Then, when you are writing the cell, concatenate the stored project value with the new project value

Hope this helps.
Best regards,
Marius

hi,

one moification : i need to write in single cell for each iteration according to the value stored in irow(0).
with done_projectname,done_projectname2 in this fasion in same cell.

Hi @Mathkar_kunal

for each iteration don’t add directly to excel, take a temp counter =0 and
take one new variable, use concatenation + and once all iterations completed, write that final variable to excel.

you can use as irow(tempcounter) and increment counter till full data added to final variable.

Thanks
Latika

what is the need of counter here?
Kindly find my workflow here demo5.xaml (13.3 KB)

understood what ur saying but my new value always will be in row(0) only.Little confused how can i apply the logic and how can i concatinate inside for each row loop.

How can i store in variable ?and what variable should i use ,array one?

Hi @Mathkar_kunal,

Please refer to this:
sol

Hope this clarifies
Best regards,
Marius