Intersection of Collection Data

[PrimePrism]

Hi,

I have two collections with same columns in both of them. The only difference is the first one will have more data than the second one. My purpose is to get the uncommon data from both the collections and copying them to a new pre-defined collection. I do not want to loop through collections as it might take some time with huge amount of data. Is there any function readily available to do this? Or, could you provide any simpler way to achieve this?

Thanks

 

[Sachin_Kharmale]

Yes you can do with blue prism and it will work faster.
1.Add new action to Blue Prism Utility-Collection Manipulation object as "Get Uncommon Data From Collection".
View attachment 1561633318674.png
2.Add code stage on the page
View attachment 1561633338105.png
2.Input will be SourceCollection1 , SourceCollection2 , and any column name
View attachment 1561633367170.png
3. Output will be collection with uncommon data.
View attachment 1561633385276.png
4.Put the bellow code in code stage.
View attachment 1561633412986.png
5.You will be get desired output.

I hope it will help you.

 

[PrimePrism]

Thanks for the reply.

I couldn't find anything like 'Get Uncommon Data from Collection' or am I missing something here? Or may be it is an extended Collection manipulation that is newly built for the purpose using the code stage?

Thanks..

 

[Sachin_Kharmale]

You need to extend the functionality of Blue Prism Utility-Collection Manipulation VBO by adding new action in it.