This content has been marked as final.
Show 3 replies
-
1. Re: Collating lots (40+) of big excel files (500K+ rows) into a single source…
Dmitry ChirkovJul 22, 2016 1:17 AM (in response to Michael Carpenter)
Just as an experiment I'd try legacy Excel connector with Custom SQL (see my old post here)
SELECT [DATA$].[ID] AS [ID], [DATA$].[Name] AS [Name] FROM [DATA$] UNION ALL SELECT [DATA$].[ID] AS [ID], [DATA$].[Name] AS [Name] FROM [C:\files\another-file.xlsx].[DATA$] UNION ALL ...
It will probably be just as slow but at least you can fire up extract creation and go get lunch.
-
2. Re: Collating lots (40+) of big excel files (500K+ rows) into a single source…
Michael Carpenter Jul 22, 2016 2:42 AM (in response to Dmitry Chirkov)Thanks for getting back to me. Can you tell me how I get to the option to
enter a custom SQL statement - I can't see that as an option on the
'Connect .. to a file' screen?
Michael
On 22 July 2016 at 09:18, Dmitry Chirkov <tableaucommunity@tableau.com>