two column in a table

KNIME Analytics Platform
1

Hi, I have some questions about two columns comparing as following:

column1    column2 

    A              B

    B              A

    C              D

    B              D

How can I use nodes to only generate one pair of A to B (deleting the duplicate pair)geting the following table:

column1    column2 

    A              B

    C              D

    B              D

2

Hi dreaming,

first you need the Column Aggregator node, using option "sorted list". Then you need a GroupBy node, grouping the sorted list column. In the manual aggregation tab of that node you can select your column1 and column 2 with the aggregation method "First".

Best regards,
agaunt