I have a table containing an ID and number attribute. ID's are not unique. I need to identify all the ID's that have different number attribute values.
180160210021003603100This example will return ID=1 and ID=3
Page 1 / 1
Hi @etienne, there are probably many ways to solve this, this is my take on it.
Hope this helps
I've done it with a ListBuilder, grouping by ID. Then a ListDuplicateRemover, so if there's duplicate values for an ID (ID=2 in this case) they get condensed to a single element, then a ListElementCounter. Any list with 1 element is an ID where the attribute values are all the same, so a TestFilter to check where the element count is more than 1 yields the ID's where there's different attribute values.
Hi @etienne, there are probably many ways to solve this, this is my take on it.
Hope this helps
Almost the same solution but you beat me by 13 seconds :)