Skip to main content
shaikg2747
shaikg2747
May 11, 2023
Question

Need Help on Expression Rule!!

  • May 11, 2023
  • 5 replies
  • 0 views

From the above pic,

in the local variables bankruptcy there will be constant 4 values and in the local variable creditPublicRecord there will be some values can be null or more than 1 value.

Here we have to compare the creditPublicRecord values with the bankruptcy values and check whether the the creditPublicRecord values matches the bankruptcy values and need to return the count.

Can someone suggest the way to complete this.

Thanks In Advance,

Gousii.

5 replies

harshitb6843
harshitb6843
May 11, 2023

You can compare both of these just by using the = operator. Try local!bankruptcy = local!creditPublicRecord and it will give you the result. If you want to compare them in any other way, then please mention it. 

shaikg2747
shaikg2747Author
May 11, 2023

I have to compare each and every value of creditPublicRecord with the constant values of bankruptcy.

for example from the above snap,

local!creditPublicRecord has one value(judgement) and we have to check if that "judgement" matches with the bankruptcy value and if it matches then we need to count the number of matches. As there is no judgement in the bankruptcy so count is "0"

If local!creditPublicRecord has these values{"judgement","BankruptcyChapter11","BankrptcyChapter7","Other"} then we have to check how many times the values of local!bankruptcy matches the values of local!creditPublicRecord.

stefanhelzle0001
stefanhelzle0001
May 11, 2023

Is this like an intersection of the two lists of values? If yes, there is an intersection function in Appian. Then count the items in the result.

Terms & ConditionsAccessibility statement