show both joining columns on a join

[Catalinazm]

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

[ipazin]

Hi there @Catalinazm,

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

Then if necessary use Column Merger node

Br,
Ivan

[Catalinazm]

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

Best regards,

Catalina.