Hello,
I'm a new Alteryx User trying to figure out something that should be simple.
I have two data sets that I joined and I'm trying to capture 'all' the results. Meaning I want to see results from the Left (L), Joined (J) and Right (R). To combine each of the results sets, I brought in a Union app and have 3 arrows going from each of the L,J & R tabs into the Union app.
The issue I'm encountering is Record 1 above is coming from the R Join and I would expect the 1000 Gallons to be under the Gallons - F column and not the Gallons - A column. The Joins are on Year, Month, Org, Dest and Carrier.
If you click on the R Join, the data looks correct so I'm not sure why it's falling under the wrong column in the Union.
