-
1. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
1 of 1 people found this helpfulWhat you require is currently not within the functionality of Tableau.
Cross Data base joins are being introduced in Tableau 10. Currently available in the Beta version.
See Link below
-
2. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
Tom W
Jun 13, 2016 9:28 AM
You could create a view in the Access DB to pull in the data from the SQL Server.
Otherwise you'd need some sort of ETL process or middleware to pull everything together.
-
3. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
1 of 1 people found this helpfulIf this is an urgent requirement and you cant wait for Tableau 10 look at tools like Alteryx - will definitely get the job done for you.
Alteryx can perform ETL task without coding and create Tableau Data Sources.
-
4. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
Wouldn't tableau's function "append from data source" help?
-
5. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
Wouldn't tableau's function "append from data source" help to achieve this?
Thanks a lot for your comments.
-
6. Re: Appending data (one below the other) from multiple databases containing similar data with varying table structure
I want to append the data vertically (same no of columns, but more no of rows). Something like a union where for an example; the sales data from March (SQL Server) needs to be combined with that of January and February (MS Access) to visualize the sales in the quarter.
Would "append from data source" suffice the requirement?
Appreciate your valuable comments!