topic Copy a range of column from one collection to another collection in Product Forum

topic Copy a range of column from one collection to another collection in Product Forum https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71966#M24571 Hi ,I want to copy range of column of a dynamic collection to another collection but in utility collection manipulation it is only available for the row. Please suggest .   thanks  Tue, 05 Jun 2018 12:29:00 GMT sumitsharma1 2018-06-05T12:29:00Z Copy a range of column from one collection to another collection https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71966#M24571 Hi ,I want to copy range of column of a dynamic collection to another collection but in utility collection manipulation it is only available for the row. Please suggest .   thanks  Tue, 05 Jun 2018 12:29:00 GMT https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71966#M24571 sumitsharma1 2018-06-05T12:29:00Z If the collections aren't… https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71967#M24572 If the collections aren't huge then I'd probably just do it with diagram loops. The other option is to create a new code stage to manipulate a .Net datatable (which is what the utility objects do). Tue, 05 Jun 2018 12:58:00 GMT https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71967#M24572 John__Carter 2018-06-05T12:58:00Z hi John could you please… https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71968#M24573 hi John could you please help explain more details how to do the loops or vlookup columns in this case? i have file1 have column A, B, C, D and file2 i have column A, C, and E i want to add column E from file 2 in the file1 , and this column E will be based on the matching value looked up in the column A in 2 files. could you please help advise ? thanks a lot. jason  Sat, 09 Jun 2018 08:45:00 GMT https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71968#M24573 JasonNguyen 2018-06-09T08:45:00Z Read file1 into a collection… https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71969#M24574 Read file1 into a collection, then append a new column onto the collection. Read file2 into another collection Create a nested loop (one loop inside another) In the inner loop, compare collection1 with collection2, and decide whether to update [collection1[.[ColumnE] Write collection1 back to file1 Mon, 11 Jun 2018 13:49:00 GMT https://community.blueprism.com/t5/Product-Forum/Copy-a-range-of-column-from-one-collection-to-another-collection/m-p/71969#M24574 John__Carter 2018-06-11T13:49:00Z