Is there a straight forward way to compare the list of values on an array. I ha

Hi Hayley, would exact(pv!arrayA,pv!arrayB) work?

You should be able to use set functions to accomplish this. If you take the intersection of the 2 arrays, every item that appears in both array will be returned. If the length of each of the arrays is equal to the length of the intersection of the two arrays then the arrays must be equal. Also note, len() is for getting the length of a text value, length() will return the size of an array.

intersection() is definitely a valid approach. Few questions though..Does order matter? Do you care about duplicates? i.e. if pv!array1 = {1,2,3,4} and pv!array2 = {4,2,2,3,1}, should that return true or false?

Thank you for the replies. In answer to your questions, the order doesn't matter and neither do duplicates. I just need to make sure that for each value in arrayA there is a also a value in arrayB
Thanks

I use =if(length(difference(ri!array1,ri!array2))>0,true,false) for doing this. It doesnt matter about the order or duplicates and we use to match two CDT's as part of a dual entry process which works very well/

Hi Joel
Thank you for your response, with a slight amendment to make it fit your formula has resolved me.
Thanks everyone for your help.

@Joe - difference() works but I would make three suggestions to your rule. 1) Get rid of the if() condition. Having just the condition will already return a Boolean. 2) It should be >= . 3) Consider the edge case that array1 and/or array2 are null. Modified rule -->length(difference(ri!array1, ri!array2))>0

Hayley, Set functions are the best bet in your case. Depending on what you want as an outcome (simply a Boolean or the difference in the record), you might want to use difference() as per Rikhi's recommendation,