collection values comparsion

I have a collection and i want to compare two values (From the screenshot) if UREF01 (BDW) = UREF02(BDW)
Here UREF value contains 01 and same way BDW also contains some value likewise UREF contains 02 and BDW also contains some value. I wanted to check both BDW has same value or not.
i.e
View attachment 1546537572948.png
 

sivagelli

Well-Known Member
You may try using action 'Read Collection Field' two times passing row index value to get value of BDW in to Data Item. And, use a calc stage you can try comparison.

This works well if the collection has very limited rows as in the image, for huge collections you may have to rely on custom code or writing collection data in to Excel and use formulas to compare.

post back, how it goes!
 
Top