CODEWITHSUNDEEP
collectionsmergeblueprism
Vijetha
Vijetha

Reputation: 17

Merging two columns in a single collection

I'm having a table in Collection1 and it is having 8 columns in it. Now I want to merge Column1, Column3, Column5 and Column7. Is there any solution for those columns using blueprism

Upvotes: 0

Views: 1413

Answers (1)

Jerry
Jerry

Reputation: 71568

You simply need to copy the collection with a new column, then loop through each row to create the merged values...

Something like that:

enter image description here

  • Add Column Field9 contains the standard object Utility - Collection Manipulation, with page 'Append Field (Text)', as inputs I have [Coll1] for the input collection, "Field9" for the new Field Name and "" for the Value, as output I have Coll2.
  • The loop is on Coll2
  • Merge Columns is simply [Coll2.Field1]&[Coll2.Field3]&[Coll2.Field5]&[Coll2.Field7] with result being stored in Coll2.Field9.

Coll1 contains 8 columns, each column named Field1 through Field8. Coll2 is the new collection, it is empty before the merge.

You can choose to delete the columns you don't need afterwards, with the page 'Delete Field' from the same object (Utility - Collection Manipulation).

Upvotes: 2

Related Questions