topic RE: Insert insert/append text to a particular column in collection. in Product Forum

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

Lily.L — Tue, 20 Feb 2024 02:12:00 GMT

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
------------------------------

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

ThânDương — Tue, 20 Feb 2024 08:51:00 GMT

Hi, I think action append in collection

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

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

Lily.L — Tue, 20 Feb 2024 09:01:00 GMT

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
------------------------------

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

Mohamad_Dakkouri — Tue, 20 Feb 2024 15:15:00 GMT

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
------------------------------

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

LeonardoSQueiroz — Tue, 20 Feb 2024 18:54:00 GMT

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
------------------------------