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
+63
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.
+63Hi @etienne, there are probably many ways to solve this, this is my take on it.
Hope this helps
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.