Collection Manipulation

janejeba

Member
I need to transpose the values from collection 1 to collection2 in the following manner. Screenshot attached [Header names are fixed here]
 

Attachments

  • Collection1.PNG
    4.8 KB · Views: 40
  • Collection2.PNG
    7.1 KB · Views: 34

LeoLugo

Member
I was able to do it.
Data Items needed: Collection1, Collection2, RowIndex(Number) initial value=0, CountryNumber(Number) initial value=1 & ValueRead(Text)
1.Loop through Collection1

2.Action->Utility-Collection Manipulation->Read Collection Field
Inputs:
Row Index-[RowIndex]
Collection-[Collection1]
Field Name-"Name"
Outputs:
Value Read-[ValueRead]

3.Action->Utility-Collection Manipulation->Set Collection Field
Inputs:
Row Index-0
Collection-[Collection2]
Field Name-"Country"&[CountryNumber]
New Value-[ValueRead]
Outputs:
Updated Collection-[Collection2]

4.Multi Calc to increase both counters
 

Attachments

  • Screen Shot 2019-03-13 at 10.40.19 AM.png
    29.8 KB · Views: 34
Last edited:
Top