3 Replies Latest reply on Jan 26, 2017 1:29 PM by james.n

    Custom SQL Union of Excel worksheets

    Dave Brown

      I have multiple Excel files that I'm trying to join in tableau 10 using a custom SQL union.  The issue is that the worksheets in the two excel files are both named Sheet1.  Is there anyway to identify which workbook sheet I need in the query or do I have to get the worksheets renamed so that they come in to me differently?

       

      SELECT * FROM [Sheet1$]

      UNION ALL

      SELECT * FROM [Sheet1$]