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

hayleyw over 11 years ago

Is there a straight forward way to compare the list of values on an array. I have currently tried
pv!arrayA=pv!arrayB and len(pv!array!=pv!arrayB) but both equations return a True if the just the FIRST item has been returned. I need to ensure that all items have been found and that they are an exact match.

Many thanks...

Discussion posts and replies are publicly visible

Parents

0 revat.anandsongkit
Appian Employee
over 11 years ago

@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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 revat.anandsongkit
Appian Employee
over 11 years ago

@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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data