Hi all,
I am trying to figure out if something of the following is possible within Blueprism:
I have a set of data which I have stored into my collection that I am trying to manipulate and store into a 'master' collection. What I am trying to do is the following:
From the collection listed above, I am trying to split the items in Column C (Fruits) so that it would create the following:
As you can see, I am trying to split it where I can keep the overall row data but just manipulate it where I can 1) Have only 1 item listed for Fruits while creating new rows so that the other items are listed separately within the collection.
Note: This is just a simplified collection as there are a lot more data in the true one which I am handling.
Any suggestions or tips would be greatly appreciated!
I am trying to figure out if something of the following is possible within Blueprism:
I have a set of data which I have stored into my collection that I am trying to manipulate and store into a 'master' collection. What I am trying to do is the following:
From the collection listed above, I am trying to split the items in Column C (Fruits) so that it would create the following:
As you can see, I am trying to split it where I can keep the overall row data but just manipulate it where I can 1) Have only 1 item listed for Fruits while creating new rows so that the other items are listed separately within the collection.
Note: This is just a simplified collection as there are a lot more data in the true one which I am handling.
Any suggestions or tips would be greatly appreciated!