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?
Best answer by ebygomm
View original
+21
Do you have a table with two attributes? Or a single attribute with two values separated by a hyphen?
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.
+21
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
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
