Insert insert/append text to a particular column in collection.

[Lily.L]

Hi Guys,

I'm looking to insert/append text to a particular column within the current collection.

Within my report, I have three columns: A, B, and C. Initially, I appended text to create a new column called "Date," which is currently sitting in column D.

Now I want to insert/append text "Date" in column M, instead of column D. How can I achieve that? Thank you!

------------------------------
Mia Mikela
------------------------------

[ThânDương]

Hi, I think action append in collection 

------------------------------
Thân Dương
------------------------------

[Lily.L]

Hi. This action can only add text to the next column (in this case, it will be column D), not the particular column (I want to add text to the column M). Thanks

------------------------------
Mia Mikela
------------------------------

[Mohamad_747]

Hi,

1- Take a loop stage

2- Add a calculation stage

Inside your calculation stage you put

[Collection.column]&"your text"

And you store the result in Collection.column

------------------------------
Mohamad DAKKOURI
------------------------------

[LeonardoSQueiroz]

Hello Mia.

It can be done with the Set Collection Field action , defining a collection field, updating a single value in a collection by the given field name and row index.

Regards, 

------------------------------
Leonardo Soares
RPA Developer Tech Leader
América/Brazil
------------------------------