Join datasets but indicate Null for no matches

Question

Hi all,

I am trying the join two datasets, but in case of no matches I need empty "Null" cells in the output. Let me explain with a simple case:

Below I show two simple tables I would like to join,

IDAnswer1y2y5y

ID12345

and I would like to get the following as output,

IDAnswer1y2y5y3[Null]4[Null]

The order of the rows is not relevant.

Can you give me a hand with the corresponding tool/workflow to use?

Cheers

binu_acs · Accepted Answer

@omar_velor Join with the ID field then Union the J-anchor and R anchor of the join output