Problems to understand the Set Operator node

Hi

My confusion started actually that I have to lists in each a column that should be integrated into one list.

As I only was able to find the insert into a list for string columns (upper path) not lists into list, I kept on looking and found the Set Operator node and tried to employ it.

I converted the lists to sets, split them to feed them into the Set Operator node.

I have two problems with the result of the Set Operator node.

Orange box: I was expecting the same number of rows, one set getting integrated into the one of the other column, like [CODE,VALIDITY,KNOWLEDGE].

“Blue box”: The order of rows changed.

I cannot make out the union here… unless the Set Operator node should be a Concatenate node combined with a Group By node. Maybe, I was not reading the description carefully enough.

Cheers

Thiemo