So I want to delete the duplicates, or find the distinct combinations across two columns.
I know I can do that with SQL on a database. But I just have a table here and want to do that directly in my FME script.
Does someone has an idea?
Solved
I have a table with two Columns A and B like that: A B 1 1 1 2 1 3 2 1 3 1 7 4 4 7 And my result should look like that: A B 1 1 1 2 1 3 4 7
- Contributor
Best answer by ebygomm
You can use an AttributeCreator/AttributeManager with a conditional statement to create a new value that is always the lower value followed by the higher value. Then a duplicatefilter to get only the unique records
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.
+51- Evangelist
Do you have a table with two attributes? Or a single attribute with two values separated by a hyphen?
- Contributor
Do you have a table with two attributes? Or a single attribute with two values separated by a hyphen?
Oh sorry, I have a table with 2 columns. I just seperated the columns here with a hyphen.
I think this is missleading. I change it.
+51- Evangelist
- Best Answer
You can use an AttributeCreator/AttributeManager with a conditional statement to create a new value that is always the lower value followed by the higher value. Then a duplicatefilter to get only the unique records
- Contributor
You can use an AttributeCreator/AttributeManager with a conditional statement to create a new value that is always the lower value followed by the higher value. Then a duplicatefilter to get only the unique records
Thanks, that's it!
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.