Find Duplicate combination of two columns

KNIME Analytics Platform
1

Hi All,
I have a DB with Father and Son relarionship between Items
I need to identify two situations:
1)A-B
B-A
2)A-B
B-C
C-A
in order to clean duplicate parental relationship between items in my DB.
do you have ideas of how to do it?
here i uploaded a screenshot to explan better what i would like to obtain

image

thanks in advanced

2

Hello @Pietro_Zaza
What about ‘Cross Joiner’ of $Father$ vs unpivoted concatenated $Son$? vs again ‘Cross Joiner’ of ‘relationship rules’? Then filter TRUES

BR

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.