show both joining columns on a join

Hi everyone, I want to do a full outer join of two tables, when doing it with the joiner node the result only has one of the columns on which I joined (column of left table) but I need to have both. What I mean is I’m joining by the id column of both tables and the result only has the id column of the left table, but I need to have the ids of all the rows of right table that didn’t match ( which I can’t since the id of left table is obviously empty) , is there any way to show both id columns on the result?

Thanks,

Catalina

Hi there @Catalinazm,

Uncheck these option under Joiner node and you will have joining columns from both tables:

JoinerOpt
Then if necessary use Column Merger node :wink:

Br,
Ivan

1 Like

Thanks! I don’t know how I didn’t see it.

Best regards,

Catalina.

1 Like

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