Hi,
Follow the below steps for the solution:
1) Have two collections in place, in my case "Input Collection 1" has the fields A,B,C,D and "Input Collection 3" has the fields E,F,G both with some data present as shown below:
2) Create two collections with single row which won't have any value as we are going to use them for 'Split Collection' action in Collection Manipulation VBO such that once collection has the field A,C,D and another has field B so that we can split our input collection having four fields A,B,C and D into two separate collections one having just the field B and another having A,B and C. In my case I have two collections named, 'Collection Template 1' and Collection Template 2' as shown below:
3) Store the output of the previous action into two undefined collections whose fields need not be created. In my case, these collections are 'Splitted Collection 1' and 'Splitted Collection 2' as shown below:
4) The inputs of the Split Collection should have the collection having all four fields, A,B,C and D along with the two single row collections which we are using as templates and the output should be assigned to the above two empty collections that we created. Refer to the below inputs and outputs for the 'Split Collection' action
5) Now our 'Splitted Collection 2' holds only the field B with all the values and we have the second input collection in Step 1 which had the field E,F and G. We can simply use the 'Merge Collection' action in order to merge the 'Splitted Collection 2' with the Input Collection 3' and assign the output to an undefined collection with no field called as 'Final Collection' as shown below:
6) The overall solution flow looks like this along with inputs and outputs
------------------------------
Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
------------------------------
Follow the below steps for the solution:
1) Have two collections in place, in my case "Input Collection 1" has the fields A,B,C,D and "Input Collection 3" has the fields E,F,G both with some data present as shown below:
2) Create two collections with single row which won't have any value as we are going to use them for 'Split Collection' action in Collection Manipulation VBO such that once collection has the field A,C,D and another has field B so that we can split our input collection having four fields A,B,C and D into two separate collections one having just the field B and another having A,B and C. In my case I have two collections named, 'Collection Template 1' and Collection Template 2' as shown below:
3) Store the output of the previous action into two undefined collections whose fields need not be created. In my case, these collections are 'Splitted Collection 1' and 'Splitted Collection 2' as shown below:
4) The inputs of the Split Collection should have the collection having all four fields, A,B,C and D along with the two single row collections which we are using as templates and the output should be assigned to the above two empty collections that we created. Refer to the below inputs and outputs for the 'Split Collection' action
5) Now our 'Splitted Collection 2' holds only the field B with all the values and we have the second input collection in Step 1 which had the field E,F and G. We can simply use the 'Merge Collection' action in order to merge the 'Splitted Collection 2' with the Input Collection 3' and assign the output to an undefined collection with no field called as 'Final Collection' as shown below:
6) The overall solution flow looks like this along with inputs and outputs
------------------------------
Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
------------------------------
