[SOLVED] Filtering Duplicate Table Data
Hi all, I have a simialirty to data module setup and I'm getting the following column outputs:
FIRST_ID, SECOND_ID, SIMILARITY
The way the pages are being compared means that the first id and second id are being displayed twice, for example
3, 2, 1.0
2, 3, 1.0
They are both the same but just in a different order. 3,2 and 2,3
I've been having a look at the remove duplicate module under Filtering, however I can't seem to find the correct rule or expression to only return unique values of the first and second id once.
Many thanks,
Mckenzie
FIRST_ID, SECOND_ID, SIMILARITY
The way the pages are being compared means that the first id and second id are being displayed twice, for example
3, 2, 1.0
2, 3, 1.0
They are both the same but just in a different order. 3,2 and 2,3
I've been having a look at the remove duplicate module under Filtering, however I can't seem to find the correct rule or expression to only return unique values of the first and second id once.
Many thanks,
Mckenzie
i do not have a one operator solution for you, but the process below solves the problem. I do not know if there is an easier way to do it.
Cheers,
Martin