Hi Jane Mamas,
Which version of tableau your suing In Tableau 9.3 we have a option of Union all can you try that ? May it will help u
Sounds like Custom SQL will help here - but for that you need to know how to write SQL...
Thank you for your reply. I'm using Tableau Desktop 9.3.
Please correct me if I'm mistaken, but new 'Union' function works ONLY for Excel extracts placed in the same folder and the extracts should have exactly the same structure (same number of fields, etc.).
To access my tables I have to connect to Microsoft SQL Server and, unfortunately, I can't even see this 'Union' option available, plus those three tables have different number of fields.
But thank you for trying to help
Hi Andrew, that's what I thought as well.. But, unfortunately, I'm not an expert in SQL coding... not even a beginner
Thank you for the answer anyway
Hi Jane Mamas,
Ok Will see for better answers .....
2 of 2 people found this helpful
To be honest I think your current approach is the best you can do with Tableau.
By the way, are you aware that you can save just the datasource definition? If you do that - you'll always have a good starting point with all the joins and calculations.
Thank you for your reply! Even though it's not very optimistic
And what do you mean by 'saving datasource definition'? I usually just open my old workbook, delete worksheets and dashboards - and I get all my database connections and calculations there ready to be used. Is there a better approach?
1 of 1 people found this helpful
There must be a better way!
0. Prepare your datasource just the way you want it
1. Right click on the datasource
2. Select "Add to Saved Data Sources..."
3. Navigate to "My Tableau Repository\Datasources" folder under your Documents folder
4. Give it a good name
6. Now, launch Tableau or press icon in top right corner
7. You'll see your amazing datasource all ready to go
Handy visual guide attached
That's handy to know