How to do a join based on multiple groups?

[AmyL1]

I want to do a unique type of join, but I am not sure if it's possible. Basically, I have a list of Record IDs from 1-5:

Record ID Original

1

2

3

4

5

I have a separate table that also has Record IDs, so that's where the join would come into play:

Date	Record ID
1/30/2019	2
1/30/2019	4
2/30/2019	1

However, I want to join this so the result has something for each Original Record ID for each date. So here the output would look like:

Date	Record ID	Record ID Original
1/30/2019	NULL	1
1/30/2019	2	2
1/30/2019	NULL	3
1/30/2019	4	4
1/30/2019	NULL	5
2/30/2019	1	1
2/30/2019	NULL	2
2/30/2019	NULL	3
2/30/2019	NULL	4
2/30/2019	NULL	5

Is this type of join possible in Alteryx? The actual data I'm working with is a lot more complex than this example, so I am hoping I can automate this somehow. I am also trying to avoid adding dates to the first table and including that in my join if possible

Thanks in advance!

[DiganP · Accepted solution]

@AmyL1 I think you are looking for the append fields tool combined wtih the formula, sort and unique tool. 

Attached is the workflow.

[AmyL1]

This is exactly what I was looking for! Thank you!!