1 of 1 people found this helpful
Is there some special reason you are avoiding using Union?
Have you tried Tableau Prep - see the link https://onlinehelp.tableau.com/current/prep/en-us/help.html#prep_get_started.html
One way (and not advisable...but just to address the challenge!!) is to use the Calculation Join function.
Create a Join field with the number 1 in one Table and 0 in the other table and join on this (using FULL OUTER JOIN). This will get both tables into a UNION type situation. However (unlike a real Union) Tableau won't know that Name from Table 1 and Name from Table 2 are the same column, so will create 2, and then you'll need an IFNULL (coalesce type) formula to get them into 1. As you can image once you do this with more than 2 tables it soon becomes unmanageable!
Thanks for replying. I actually having UNION for 40 databases from 40 different servers. But from all DB the column count and names are same. I used this UNION query in Tableau and it was working fine. Now I have a centralized report for 40 servers and I can see that in one single text table object.
But when anyone of the server is down / offline due to some reasons the entire query fails. Hence I have tried to do Stored Procedure in SQL but not able to succeed. So checking if we can append the rows from all 40 server databases in tableau my job is done.
Your suggestions please.
Yes I came across this solution but I have 40 server databases to be appended. Using IFNULL will be difficult.
perhaps you can use blend, but the solution with Union or Tableau Prep could be the best for your case.
is Tableau PREP needs a separate license?
Unfortunately I am using 10.1.1 Desktop and Server. Will Tableau Prep 2018 works for me?