Join datasets but indicate Null for no matches

[omar_velor]

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,

ID	Answer
1	y
2	y
5	y

ID

1

2

3

4

5

and I would like to get the following as output,

ID	Answer
1	y
2	y
5	y
3	[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

[binuacs · Accepted solution]

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