1 Reply Latest reply on Nov 1, 2016 12:16 PM by Jeff Strauss

    Union All

    Pritesh Patel

      Hello All,


      I've been given an excel file with 50+ sheets in it.  Each sheet is for a country.  Each sheet has the exact same columns, with the same headers but the data is for each country.

      With 50+ sheets, using an SQL command such as:

           SELECT * FROM [Sheet1$]

                UNION ALL

           SELECT * FROM [Sheet2$]

                UNION ALL

           SELECT * FROM [Sheet3$].......


      This will take a long time. 

      Any faster ways of doing this in Tableau 9.2.1??