cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Get the Required Columns from a collection

saikumarkuncha
Level 2

Hi Team, Good Day!

I am trying to Get the Specific Columns data from a collection 

For Ex 

Col 1, Col 2, Col 3, Col 4

   A  ,    B    ,     C    ,  D

   C  ,    D   ,      F     ,  E

Now I want to Get only the Col 2 And the Col 4 as a new Collection. 

Like 

Col 2, Col 4

   C   ,   F

   D   ,   E

As a collection.

So kindly help me how can we do this. 

and i have searched multiple pages but no luck 

and also i have done with multiple ways to filter it kindly help me to achieve this problem.   



------------------------------
saikumar kuncha
------------------------------
4 REPLIES 4

Hi Saikumar,

You can use Delete Column action from Utility - Collection Manipulation to remove the unwanted columns from the collection.



------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

Hi SaiKumar kancha,

As other member mentioned you can use delete column activity to delete it

But if the columns are dynamic  you need to create a new collection with expected column names and loop the existing collection and update the values in the new collection



------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------
-----------------------
If I answered your query. Please mark it as the Best Answer

Harish Mogulluri

Babjee24
Level 7

Hi Sai Kumar,

As suggested by Harish you can split collections using collection manipulation but this requires predefined collections with fixed fields(expected columns)



------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------
Babjee Vangipurapu
Senior RPA Developer
India

Hello,


In addition to the suggestions above, another possible way is to use an auxiliary collection to store the values with the desired treatment, capturing only the desired columns.



------------------------------
Leonardo Soares
RPA Developer
------------------------------
Leonardo Soares RPA Developer América/Brazil