topic Could you give a snapshot of… in Product Forum

Split Collection in collection manipulation

AshvinPaisal — Sat, 18 Aug 2018 14:40:00 GMT

Hi, how do i split collection in collection manipulation. what should i put in Collection 1, Collection2 Template and Collection 3 Template in Input and in out put tab what should i put in collection 2 and collection 3 Thanks. Ashvin

Hi Paisal.Ashvin Let's say…

Mustafa_UlasYig — Tue, 28 Aug 2018 11:17:00 GMT

Hi Paisal.Ashvin Let's say you have Collection 1 with 3 fields defined: Field1, Field2 & Field3, that you give as in input to ""Split Collection"" action (as Collection 1). Then you can split this collection in 2 collections, by: 1) Creating a collection in your process with Field1 defined, that you give as in input to ""Split Collection"" action (as Collection 2 Template) 2) Creating a collection in your process with Field2 & Field3 defined, that you give as in input to ""Split Collection"" action (as Collection 3 Template). This will then give you Collection 1 split into Collection 2 and Collection 3 as output to the ""Split Collection"" action. Good luck. BR, Mustafa

Could you give a snapshot of…

MeghalVasa — Mon, 12 Nov 2018 13:03:00 GMT

Could you give a snapshot of the example as it is not clear what is to be written in Collection 2 Template & Collection 3 Template fields

If I dont know column…

MeghalVasa — Mon, 12 Nov 2018 13:05:00 GMT

If I dont know column headers then How to define the split? Basically I just need to split my collection of 4 into 2 collections with 2 fields each.

I used it sometime back, so…

ashish.easow — Mon, 12 Nov 2018 18:44:00 GMT

I used it sometime back, so you will have to check for accuracy. If your col 1 has columns, A, B,C, and if you want to plit them into 2 colls, say col 2, col3, then in templates use templates Col2 template (fields A,B), and Col 3 template (field C), with dummy rows, it will split the columns in 2 collection as the template you have given.

RE: Could you give a snapshot of…

DenzilAfriyie — Tue, 27 Apr 2021 15:43:00 GMT

Hi,

Please were you able to work this out? I have a collection with 10 columns that I need to split with the first 2 columns in a new collection and the rest in another. I see the object but I do not know how to script the calc to split it. A snapshot would be great!

------------------------------
Denzil Afriyie
------------------------------