How to join sheets with differing report dates?

[johny9887]

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

[Robin_McIntosh · Accepted solution]

If I understand you correctly, you need to add another join (on location and reporting date) before your union.

[johny9887]

Yup this is what i needed