1 Reply Latest reply on May 6, 2013 12:28 PM by Shawn Wallwork

    Append worksheets from the same workbook

    Duc Pham

      Hi,

       

      Sorry for my ignorance as this is nearly my first time posting in the forum.

       

      What's the quickest way to append 2 Excel spreadsheets with exactly the same format in Tableau? I have sales data for many companies, but the geographies are different between the spreadsheets. In one spreadsheet it's Vietnam, in the second spreadsheet it's "World".

       

      I've tried right clicking the data source >> Edit connection >> Add table, but it doesn't seem that the 2 data tables are appended. I next try to combine the identical dimensions from the 2 tables (right-clicking the dimension) but I'm not sure if that's the right thing to do. Becaues now the geography dimension says "Vietnam, World" when I drag it to Filter and open the filter up.

       

      Thanks in advance for your help!