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!
Solved! Go to Solution.
@AmyL1 I think you are looking for the append fields tool combined wtih the formula, sort and unique tool.
Attached is the workflow.
This is exactly what I was looking for! Thank you!!
