Hi,
I would like to filter out whether a certain value appears multiple times in either of two fields. An example:
ID1ID2Desired action1_22_1keep1_33_1keep2_11_2discardCurrent attempts have either given me the rows which don't ever appear twice across the two fields, or a full list of those that do appear twice across the two fields. Is there a way to filter out duplicates looking at both fields?
Best answer by erik_jan
Create a test field (ID3) using the AttributeCreator. Use the Conditional Values to set the value as follows:
If ID1 > ID2 then ID1-ID2 (use Text Editor to concatenate)
Else ID2-ID1
Then use ID3 in a DuplicateFilter to find the unique combinations.
+18Create a test field (ID3) using the AttributeCreator. Use the Conditional Values to set the value as follows:
If ID1 > ID2 then ID1-ID2 (use Text Editor to concatenate)
Else ID2-ID1
Then use ID3 in a DuplicateFilter to find the unique combinations.
Create a test field (ID3) using the AttributeCreator. Use the Conditional Values to set the value as follows:
If ID1 > ID2 then ID1-ID2 (use Text Editor to concatenate)
Else ID2-ID1
Then use ID3 in a DuplicateFilter to find the unique combinations.
Many thanks, that's done the trick!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
