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

    Union All

    Pritesh Patel
    Pritesh Patel Nov 1, 2016 11:05 AM

      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??

       

      Thanks.

       

      -Pritesh.