Unable to Get the Required Columns from a collection

[saikumarkuncha]

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
------------------------------

[shashank.kumar280]

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
------------------------------

[harish.m]

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
------------------------------

[Babjee24]

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
------------------------------

[LeonardoSQueiroz]

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
------------------------------