Compare collections

[CamiCat]

Hello friends,

how is it possible to comapre two collections, which are generated by extracting two Worksheets as Collections in Excel?
Thank you so much for your precious help,
Cami

 

[Sukesh Kumaru]

Hello,

By using Actions from :

Utility - Collection Manipulation

Collection Contains Field
Collection Contains Value

Good Luck.

 

[CamiCat]

Hello @Sukesh Kumaru,
Thank you so much.
Can you please provvide me an sample with some screenshot?
Thank you so much

 

[Sukesh Kumaru]

Hello,

use coll1.column1name=coll2.column1name
if both are same, it returns a flag value, based on this make a decision to move that particular record or not.

use Collection Contains Value=Coll1.col1value (in this, in every iteration it checks with the value present or not, if yes returns a flag value, based on that make an operation)

Good Luck.

 

[CamiCat]

Thank you so much @Sukesh Kumaru ,

How to do in BP these steps: check coll1.column1name=coll2.column1name?

if both are same, it returns a flag value, based on this make a decision to move that particular record or not.

View attachment 1548921028249.pngCan you please help me?
Thank you ,
Cami .)

 

[Sukesh Kumaru]

Hello,

Be specific, what exactly you want to validate or check between 2 collections and perform that operation in looping.

Good Luck.

 

[CamiCat]

Hello @Sukesh Kumaru,

I need to check if, between the two collections, there equal rows.
For equal rows I mean rows which have 3 column values equal.
Can you please give me som indications?
Thank you,
Cami