Get few columns from collection

[Murali_MohanKon]

Hi, we have 7 columns (Name,ID,Salary,date,age,grade,percentage) in collection but i need only 4 columns(Name,ID,date,age) data from the collection. how to fetch only 4 columns from collection.   Thanks Murali

[SivakrishnaVadl]

Hi Murali, To delete unwanted fields in a collection, identify the required fields and them add in a collection. Get all the field names in your input collection into another collection and loop through it. Delete the unwanted field names in the input collection using and save to an output collection. Refer to the attachment. Please let me know if you have any questions. Sivakrishna Vadlamudi +918807250680

[John__Carter]

Another option is to use an OLEDB query to read only the columns you want.

[Murali_MohanKon]

Thanks a lot Sivakrishna Vadlamudi & John Carter its working.

[suneel_kumarguv]

mkonanki i am trying to do the same thing by using OLEDb, but am not getting ,could you please tell me the process? 

[JasonNguyen]

Hi Siva, i also have the same question as above. However, i did try and it seems doesn't work : (  may i need your help to clarify as below steps: 1. open a collection to have all required columns, by adding fields and type in the fields names (which are the columns we want to keep), right ? 2.  next, we create loop, the data input using in this loop is the collection which contains all the columns, right? 3. then, create an action Delete column, between the loop , and in this action property, the input will be the collection created at step 1 (contains only required columns) ? and the column name : what to put there ? are the above correct? appreciate your kind advices... jason 

[John__Carter]

https://help.blueprism.com/1136332732