How to create small collection from main collection ?

[SwatiAgrawal]

Hi,

How can I create small collections from main collection. For Eg: The below screenshot shows the main collection. Now, I want to fetch values of Column3 & Column4 into a separate collection. How can I do that ? 




------------------------------
Swati
------------------------------

[John__Carter · Accepted solution]

The collection utility VBO has a Split function where you provide it with 3 collections A) your original collection, B) an empty collection with the columns you want, C) an empty collection with the columns you don't want. Eg B) would be Column3, Column4, and C) would be Column1, Column2, Column5, Column6 etc.

Another crude but effective technique is to simply loop through the collection and use 2 calcs to assign values of columns 3 and 4 to the new row of another collection.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[AndreyKudinov]

If you just need to get a few columns, you can just use same template collection for B and C - code will ignore C and should work faster.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------