Thanks .. I can do the shift and drag once the excel sheets are all available . .but before that I need tableau to load these excel sheets (around 20 of them) .. I used to press "Add new" then the file name .. I have to do that 20 times now ..
Is there a way to just select a folder (as it's obvious from the image I attached above), so i have all the excel sheets loads at once?
1 of 1 people found this helpful
The sheets must be in the same workbook of excel else we treat them as distinct data sources.
In Tableau 9.3 you can UNION csv or txt data manually if they are located in one folder.
If all relevant text files for a multi-table connection are collected in a single directory, with nothing else in that directory, there is no possibility that users will inadvertently select a file that is not appropriate for the connection.
Text File Data Source Example
An example of a text file data source is shown below.