Need difference set of data from rule input, local variable.

Question

Hi, 
 I have a rule input with multiple rows of data and I also have a local variable with few rows of data. 
 Now I want to find the difference rows of data into a another local variable. 
 Is it possible in appian. 
 Any inputs please.

Konduru Chaitanya · Accepted Answer

Hello swapnar6405 , 
 You can use symmetricDifference() to get the unique values that are there in both set A and set B. 
 Here is an example 
 a!localVariables(
 local!data1: {
 a!map(name: "kevin", age: "23", gender: "Male"),
 a!map(name: "Rambo", age: "26", gender: "Male"),
 a!map(name: "Jude", age: "33", gender: "Female"),
 a!map(
 name: "Michelle",
 age: "21",
 gender: "Female"
 )
 },
 local!data2: {
 a!map(name: "kevin", age: "23", gender: "Male"),
 a!map(
 name: "Fracesca",
 age: "22",
 gender: "Female"
 ),
 a!map(name: "Jude", age: "33", gender: "Female"),
 a!map(name: "Martin", age: "53", gender: "Male"),
 a!map(
 name: "Michelle",
 age: "21",
 gender: "Female"
 )
 },
 local!unique: symmetricdifference(local!data1, local!data2),
 { local!unique }
)

Mike Schmitt · Answer

the cheap and easy way would be to use the difference() function. It's probably picky about your data type, so it might be necessary to cast the local variable as the CDT type before passing it through that function. Also note that it would return a difference even for the tiniest change in data.

Need difference set of data from rule input, local variable.

Top Replies