topic Re: Compare values from 2 collections A vs B in Product Forum

Compare values from 2 collections A vs B

LorenzoCapoccia — Thu, 29 Apr 2021 05:52:01 GMT

Hi, I am not sure if questions can be answered 1 time only or more, so I am raising a new one in regards to the below link for similar but as follow -up,
thank you for your time

https://community.blueprism.com/communities/community-home/digestviewer/view-question?ContributedContentKey=9e39565b-7257-417f-8953-0a4a4eb7e707&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer

I am adding the current set up with each stage screen shot and final screen shot with exception, instead of checking for the 2 mismatch lines...
I think I didn't add the formula correctly, but I cannot see where the error is, or if the formula is ok, I cannot think what I should include in this?
I hope you can help, thank you

Re: Compare values from 2 collections A vs B

Ben.Lyons1 — Thu, 29 Apr 2021 10:07:00 GMT

Hi Lorenzo,

If each collection row needs to be exactly the same, i.e. Coll1.Row1.Value = Coll2.Row1.Value. You may find the action "Read Collection Field", as you can specify the field and row number. Use this against both collections, with the row number getting updated after each check. (You could do an initial row count to check the size of each collection).

Getting the value from each collection, you can compare them in a decision. Then once the row number exceeds the row count, you are finished.

If it doesn't matter what row the values are in, perhaps a filter (into a separate collection, to maintain the original) will better show if the value exists as required.

Let me know if you need either of those ideas better explained.

Thanks

Ben

Re: Compare values from 2 collections A vs B

LorenzoCapoccia — Thu, 29 Apr 2021 11:54:40 GMT

Thank you very much