Objects: How can I filter a dynamic data collections

[keithmcdowell]

HOW-TO  
STEP 1

• 1. I read a table from a website (DONE)
• 2. loaded into a data collection action (DONE)
• 3.I need to remove unwanted rows

STEP 2 

• 4. I need to combine data in two groups
• 5. make data available in my Process

I should tell you that today is my first day !!!!

------------------------------
keith mcdowell
------------------------------

[KrishnaA]

Hello Keith,

Think you figured out the solution by now.   Sorry for the delay on behalf of the community to address your query.

In case you are still looking for a solution, suggest you explore the actions of Excel - Extended VBO.   This VBO has actions that can fulfill your requirements.  Refer VBO documentation on how to consume actions published by this VBO.

Best regards,

------------------------------
Krishna A
Blue Prism
------------------------------

[EVIPUTI]

You cant remove any rows from collection directly there are other indirect ways to do that which you can find here
To combine the groups you can merge collection . And simply pass the final collection as a output parameter in end stage of object to get it in process.

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------