Data Collection 'V-lookup' to create 1 master collection

[whitehouse-UoL]

Hi All,

Please can someone help?

I am trying to create a data collection to add to a work queue which contains all the data I require to complete my workflow.

The data I start with is this:
 

Created from the system I am working in. Each option in the ‘Recommendation’ column/field has a corresponding code defined below.  

What I would like to achieve is a data collection that looks like this at the end. Which I can then pass into a work queue to work from.

Thank you! 

[rokkam_saiteja]

Hi @whitehouse-UoL 

Try this 

After merging you can remove unwanted column from the main collection by following these steps

in decision box [Collection Fields.Field Name]="not req column name"

Thanks

[whitehouse-UoL]

Hi @rokkam_saiteja 
Thank you for your reply. I have given this ago and I am not getting the results I need. This just seems to be adding the to collections together.

I need the information in the new collection to contain all the IDs and recommendations and have the Code and Comment column generated on the recommendation column. 

Thanks. 

[rokkam_saiteja]

Merge all collection to Main Collection Keep IDs, recommendations and coding fields and delete the other.

then use append field action, mention field name then u can see this below

based on the recommendation column value u can set the comment by using calculation stage to the copy and paste field in main collection

Thanks

[Mohamad_747]

Hi @whitehouse-UoL 

Try to use VBO Millicom 

https://digitalexchange.blueprism.com/dx/entry/35840/solution/millicon---collection-utility

You have the action group by.

Let me know if it's is worked for you 🙂