Hello ,
i would like to find duplicate of specific column
As example
Column A contain
i would like to find all duplicate values at column A ,consider the values as duplicated in case a-b or b-a
i mean , 3 above values consider are matched .
the target to ignore order of each cell
How could I achieve it ?
thanks in advance
FME 2021
+30
Hello
Yu can use the transformer DuplicateFilter.
Thanks in Advance,
Danilo
+13
These are the steps I used (FME 2021)
This also works with more than 2 values in the cell.
+13
An alternative method would be to use a ListSorter, instead of the ListHistogrammer, and follow that up with one ListConcatenator before going to the Matcher.
Both methods worked when testing with your sample data, however results varied once I made the values more complex. You could test out both methods with your actual dataset to determine which is preferred.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
