2 Replies Latest reply on Sep 21, 2012 9:59 AM by Eric Tobias

    What is the best way to join data spread across multiple worksheets?

    Eric Tobias

      I have now run into this issue a few times and can't find an elegant solution for it. I have Excel worksheets produced by a client and they have data spread across multiple worksheets by month. For example, their sales numbers broken down by month where each month has a worksheet in the workbook. I know how to bring multiple data sets in and create joins, but this would require a "UNION" type of join, which isn't an option.

       

      Obviously I could also connect to each worksheet and have twelve data sources in the workbook, but that would make a lot of trouble for the Tableau worksheet and dashboard creation process.

       

      How else can I combine the data from multiple worksheets into a single data source?