Modify Collection Objecct

[KPrasanth9]

Hi Team,

I have taken an excel file with lots of data(approx 2000+ rows) into collection but i just need to keep the data in a specified format as explained below could you please help me in achieving this also i have to include another column called Priority which contains a Static value 4-Low, please let me know how to achieve that

Collection 1 :
Name, Place, Animal, Task, Type

Updated Collection1:
Place,Task,Name,Type,Animal, Priority

Regards,
Prasanth

 

[cs.andras]

Hi,
Well, I'd suggest a loop on the original collection, referencing the fields separately when adding a new row to the other collection. [Collection.Field1] [Collection.Field2] ...etc.

 

[KPrasanth9]

But this will effect the performance is there any way called cut and paste for the collection object??

 

[RDawson9]

Hi @KPrasanth9

I'm wondering if it might be simpler to re-arrange the Excel sheet before converting it into a Collection. You could use the "Copy & Paste Worksheet Range" action to create a temporary second worksheet which has the values in the desired order and then read this into a collection. Then loop through the collection and add the new Priority value for each row, which shouldn't take long at all.

Rob

 

[achhabra]

What is Priority column should first column of the collection?