Solved Getting Specific Column from one Collection to another Collection

[Babjee Vangipurapu]

Hi,

I've a collection with multiple columns and multiple rows. I need all rows data of the first column into another collection.

For instance a collection having fields Name, Age, Company. I need the complete name column into another collection.

 

[Babjee Vangipurapu]

You can use action "Append rows to collection" in Utility - Collection Manipulation.

Hi Shweta,

Thanks for the response.

When we use Append Rows all the columns will be added from First collection to the second whereas I need the data as the following way

PFA for data. When I read the excel and get that data as a collection I'll get Data as Complete Data.jpg, now I want to get only Names column into a seperate Collection which will look like Single Column.jpg.

 

[Manikanta]

Hi,

I've a collection with multiple columns and multiple rows. I need all rows data of the first column into another collection.

For instance a collection having fields Name, Age, Company. I need the complete name column into another collection.

Hey @Babjee Vangipurapu
go for get collection and filter that collection with "collection name.column name" data then u can get ur data

 

[gil.silva]

Hello,

You can use the action: Split Collection from Utility - Collection Manipulation

 

[Babjee Vangipurapu]

Hey @Babjee Vangipurapu
go for get collection and filter that collection with "collection name.column name" data then u can get ur data

Hi Manikanta,

Thanks for the reply.

I've tried filtering by "CollectionName.ColumnName" but this is giving me an error. Following is ht error:
Could not execute code stage because exception thrown by code stage: Syntax error: Missing operand after 'Request' operator. This is the error I'm getting.

 

[Manikanta]

Hi Manikanta,

Thanks for the reply.

I've tried filtering by "CollectionName.ColumnName" but this is giving me an error. Following is ht error:
Could not execute code stage because exception thrown by code stage: Syntax error: Missing operand after 'Request' operator. This is the error I'm getting.

Otherwise try once @gil.silva said..
I too agree with his suggestion...

 

[Babjee Vangipurapu]

Hello,

You can use the action: Split Collection from Utility - Collection Manipulation

Hi Silva,

It has worked thanks for the idea. Thanks a lot!!

 

[DheerajRPA]

Hi,

I assume you have 2 columns of extracted data in collection named coll1. Use one more collection coll2 with single column 'name'. Put one loop for the collection coll1->Action Collection(Add row)->Use Calculation stage and give expression [coll1.name] and store in coll2.name. Once the loop completes you will have the data ready

 

[Babjee Vangipurapu]

Hi,

I assume you have 2 columns of extracted data in collection named coll1. Use one more collection coll2 with single column 'name'. Put one loop for the collection coll1->Action Collection(Add row)->Use Calculation stage and give expression [coll1.name] and store in coll2.name. Once the loop completes you will have the data ready

Hi Dheeraj,

I agree with your idea but if the data is lil higher this would be a time taking process. Appreciate your idea.