If you go to your data source and edit the union, you should see a Sheets section and a Workbooks section. If you leave the Sheet section blank, Tableau unions all sheets/tabs within the Excel workbook you have specified. However, if you also delete what is in the Workbooks selection (or include a partial format with a * for the parts that change), Tableau will union all sheets in all workbooks in the current folder. You can also check the boxes to go up a folder or down to sub-folders.
I think the deletion of the workbook name is what you're after. Hope that helps.
No the reason I posted is we have multiple files,
multi files -> multi tabs
in this scenario I cannot manually put all tabs in one place, its too much of manual work
Tableau will union all sheets in all workbooks
can u provide a sample of attachment that unions all shetts in all files located in a folder?
1 of 1 people found this helpful
You don't need to put all the tabs in one place. Just all the Excel files in one place.
I can't provide a sample attachment as your directory won't be the same as mine, but the screenshots may help.
First, connect to a new data source and select Excel as the file type. Then navigate to the directory where your Excel files are. I went to my Datasources file in My Tableau Repository, but use whichever location makes sense for your files:
Pick any file - this is irrelevant. We're just establishing a connection to this directory (Ben Neville >> My Documents >> My Tableau Repository >> Datasources). Next, grab the New Union part from the left side, and drag this to where it says Drag Sheets Here. Tableau will pop open a Union dialog. Make sure you select the Wildcard (automatic) tab/option (circled in red below). Delete what you see in the Workbooks section (highlighted below) that includes the file name. You should see something like this:
Next, select OK. Tableau will create a single data source with all sheets/tabs/files unioned. You will find 2 fields - Path and Sheet. Path refers to the file name and path, while Sheet refers to the specific sheet within that Excel file/workbook. If you drag these into a worksheet in Tableau on their own, you should see a list of all files and sheets in that folder. I had 7 Excel files, each with 1 or more sheet, so I see something like the following:
You will want to make sure your files contain the same column structure. Mine don't as they're completely unrelated files, so if I started dragging columns in, I would find many Nulls as they do not line up properly.
I was using 10.0
is it possible in 10.2 may be? or higher? will ask our admin to upgrade all my tableaus