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.
Discussion posts and replies are publicly visible
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.
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.
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.
Is this what you need?
a!localVariables( local!bankruptcy: {"Chapter1", "Chapter1", "Chapter3", "Chapter4"}, local!creditPublicRecord: { "Test", "Chapter1", "Chapter2", "Other" }, a!forEach( local!creditPublicRecord, a!map( item: fv!item, count:count(where({fv!item} = local!bankruptcy)) ) ) )
Or like
a!localVariables( local!bankruptcy: {"Chapter1", "Chapter1", "Chapter3", "Chapter4"}, local!creditPublicRecord: { "Test", "Chapter1", "Chapter2", "Other" }, length(wherecontains(local!creditPublicRecord, local!bankruptcy)) )