Hi,
The title is confusing but essentially:
- 1date file: it only has 2020-6-30 data as it is a file that will continuously update from this point on
- Joined file: contains the LocationNumber and 12 month data for 10001 branch
I tried joining the 2 together using the "Union" tool but instead i got the following:
I want it so that I have 2022-6-30 row to have the HR1, HR2 data combined with the rest of the data from joined file instead of having its own row. In addition, I want nulls for the other months data as it does not have the HR1, HR2 data
Thank you
Solved! Go to Solution.
If I understand you correctly, you need to add another join (on location and reporting date) before your union.
Yup this is what i needed