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

swapnar6405 1 month ago

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.

Discussion posts and replies are publicly visible

Top Replies

Mike Schmitt 1 month ago +1 suggested
Certified Lead Developer

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...
Konduru Chaitanya 1 month ago +1 verified
Certified Associate Developer

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...

Parents

0 Mike Schmitt
Certified Lead Developer
1 month ago

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.
Cancel
Up +1 Down

Reply

Verify Answer

Reject Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
1 month ago

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.
Cancel
Up +1 Down

Reply

Verify Answer

Reject Answer

Cancel

Children

No Data