Question

How can I extract values with duplicate criteriaCode? (Remove one item and leave other)

Forum|Forum|2 years ago
July 16, 2024
5 replies
0 views

local!combinedCriteriaResults: a!flatten(
    {
      local!test1.criteriaResults,
      local!test2.criteriaResults,
      local!test3.criteriaResults,
      local!test4.criteriaResults
    }
  ),

Local variables show there is two items with the same criteriaCode. How can I remove one item and leave the other with the same code?

data

venkatrea696188

You can use union() Function, but can you tell me more about requirement .

a!localVariables(
  local!test1:{1,2,3,4},
  local!test2:{1,2,3,4,5,6},
  local!combined:a!flatten({local!test1,local!test2}),
  union(local!combined,local!combined)
)

D

domagojk5809Author

The requirement is to remove one of the duplicate items from the local!combinedCriteriaResults

stefanhelzle0001

Brainy

Using union() and count() you can detect any duplicates. Then, for each item in the union, you can just pick a single item from the list. displayvalue() comes to my mind.

Question is, how do you decide which item to pick?

Sign up

Login with SSO

Login to the community

Login with SSO