Can you be more specific while asking something that you are trying to explore in Blue Prism.
Okay let's get in to the picture.
According to my understanding, col1 value can be extracted from a collection by using "collectionname.column_name" and store that value in a data item(use this in expression editor of calc stage), if you use this syntax in between a Loop stage then all the col1 values are picked one after the other, and use accordingly.
If your query is not this, then please don't hesitate to reach me out.
please specify the colnname.colmnname in the place of "reverse" or else it can be achieved by using a multi-calc stage
first expression is "source_collnname.06/19/18" and store result in any data item(for ex."colval") and in
next expression is: "colval" and store result in "target_collnname.colmnname".
If you do not want to loop through the collection and would like to avoid coding then this can be achieved by doing the below
- First count the total number of rows in URL_credentials because at design time you won't be sure how many rows are there
- Then copy those many rows to a new output collection ('Result' in below diagram)
- Delete all the unwanted columns from 'Result' so that only the column you want remains in the Result collection.
The Delete Column supports deleting one column at a time.
Please post back with more details if you are looking for something else.
Your solution is perfect for less no of columns, but I have a situation where I have to delete multiple columns (>1000) and retain just 1 column in the collection. Deleting 1000 wont be that much time efficient as it would run inside a loop, instead is there any other functionality either in Collection manipulation or MS Excel VBO where I can just copy 1 column & its entire data in other collection. Or I will have to use a custom code for it as well?
This will depend in how your columns are - sequential or non-sequential.
If sequential (eg; A, B, C) then you can directly use the 'Get Worksheet Range as collection' as "A1:C100" into a single collection.
If non-sequential (eg; A, C, E), then there are two options-
a. Use 'Copy and Paste Worksheet Range' for each of these columns to another (temporary) sheet. Pretty simple if you correctly give the source and destination parameters.
Once you have the columns one after the other, then using a 'Get Worksheet as collection' will give all three columns in a single collection.
Then you can clear off the sheet or delete it.
b. Another option is to get the data from individual columns of the sheet and then merge the collections as advised by Emil.Tophoej.
Instead of deleting all those unnecessary columns from collection before getting the data from excel (I guess), if the data is in excel file then you can follow a easy approach to get the required amount of data from bulk, i.e. by using "Data-OLEDB" VBO write a simple SQL Query and bring the required data from it to collection.