cancel
Showing results for 
Search instead for 
Did you mean: 

Extracting Data From A Collection

FuadMoalin
Level 3
Hi,

I am trying to extract all the data that is stored in the data column (Row 1 of 1) in the collection below. Not sure on how to do it.


36544.png
1 REPLY 1

PvD_SE
Level 12
Hi Fuad,

I did not find a 'Copy Column' stage in one of the Collection objects we have in V6.5, but perhaps one has been added in a later version.

If not, then you have several options to accomplish this:
  • Copy the complete collection to a new one and remove the columns you don't need
  • Read through the collection with a loop stage and copy the Item Id of each row to a new collection by adding a row to the new collection and copy the value from the old to the new with a calculation stage
  • Write a Code Stage to copy one column from the old collection to a new collection (I'm quite sure that such a code stage probably exists on this forum) 

Happy coding!
---------------
Paul 
Sweden
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)