3 Replies Latest reply on Oct 5, 2016 9:17 AM by Hannah Forristall

    New to Tableau 10 - Question about Unions

    Hannah Forristall

      Hi,

       

      I am a new Tableau user and I'm having an issue when trying to load in my data. The data is POS sales data by week and it is split across 2 Excel spreadsheets as there are too many rows for just one. Both spreadsheets have the same column headers (Store #, Item, Description, Units Sold, Date, Week #). I've brought both spreadsheets into Tableau and created a Union with an inner join on the store # column. When I validate the data, the unit sales are hugely inflated, I'm assuming that there's an issue with how I've done the join but I'm not sure how to fix it.

       

      Any advice on what I can do to fix this?

       

      Thank you!