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?
Discussion posts and replies are publicly visible
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) )
The requirement is to remove one of the duplicate items from the local!combinedCriteriaResults
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?
I saw your data Only code is repeating remaining things are changing for example criteriacode :C020 had 3 rows in which cdeCall is different , are you sure you call them duplicates??.
Stefan Helzle said:Question is, how do you decide which item to pick?
Union will work but ,I too have this question...
A working code example:
a!localVariables( local!data: { a!map(id:1, crit: "a"), a!map(id:2, crit: "a"), a!map(id:3, crit: "b"), a!map(id:4, crit: "b"), a!map(id:5, crit: "b"), }, a!forEach( items: union(local!data.crit, local!data.crit), expression: displayvalue(fv!item, local!data.crit, local!data, {}) ) )