topic RE: How to create small collection from main collection ? in Product Forum

How to create small collection from main collection ?

SwatiAgrawal — Mon, 05 Apr 2021 17:13:00 GMT

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

RE: How to create small collection from main collection ?

John__Carter — Tue, 06 Apr 2021 10:02:00 GMT

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

RE: How to create small collection from main collection ?

AndreyKudinov — Wed, 07 Apr 2021 12:19:00 GMT

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