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.
Union is not available in 9.2, but if you can upgrade to at least 9.3, then union is built-in. See this post:
Combine Your Data with Union in Tableau 9.3 | Tableau Software