How to save a value（const） in excel's row processing

Help StudioX
,
1

There is a table on top of the web and I want to concatenate the values of each row of this table and write them to excel. I try to save to the value, but because of the per row processing, the value is always the content of the current row.
The web table is assumed to look like this.
ID
A
B
C
Eventually, I want to get an ABC written to excel

2

Hi,

you have to write assign activity like below to get final text in the end of the loop. so you will get the final text like ABC. thanks

Finaltext= FInaltext+currentrow(“ID”).tostring

1 Like
3

would you give me a sample？thanks
I have no experience about that

4

Hi,

Please refer the below sample work flow. let me know if you have any additional query regarding for this. thanks.

ConcatDemo.zip (9.5 KB)

5

Thank u very much.

1 Like
6

Your most welcome.

7

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