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
Question
Find ID where attribute value differs
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+19- Supporter
Hi @etienne, there are probably many ways to solve this, this is my take on it.
Hope this helps
+62
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.
+62Hi @etienne, there are probably many ways to solve this, this is my take on it.
Hope this helps