topic https://help.blueprism.com… in Product Forum

Get few columns from collection

Murali_MohanKon — Sun, 20 May 2018 17:15:00 GMT

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

Hi Murali, To delete…

SivakrishnaVadl — Mon, 21 May 2018 00:53:00 GMT

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

Another option is to use an…

John__Carter — Mon, 21 May 2018 14:02:00 GMT

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

Thanks a lot Sivakrishna…

Murali_MohanKon — Tue, 22 May 2018 06:38:00 GMT

Thanks a lot Sivakrishna Vadlamudi & John Carter its working.

mkonanki i am trying to do…

suneel_kumarguv — Tue, 22 May 2018 10:37:00 GMT

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

Hi Siva, i also have the…

JasonNguyen — Sat, 09 Jun 2018 08:32:00 GMT

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

https://help.blueprism.com…

John__Carter — Mon, 11 Jun 2018 13:51:00 GMT

https://help.blueprism.com/1136332732