Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to join sheets with differing report dates?

johny9887
7 - Meteor

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

johny9887_0-1658262097035.png

 

- Joined file: contains the LocationNumber and 12 month data for 10001 branch

johny9887_1-1658262115825.png

 

 

I tried joining the 2 together using the "Union" tool but instead i got the following:

johny9887_0-1658259290569.png

 

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

2 REPLIES 2
Robin_McIntosh
11 - Bolide

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

Robin_McIntosh_0-1658264282686.png

Robin_McIntosh_1-1658264331011.png

 

 

johny9887
7 - Meteor

Yup this is what i needed

Labels