I have 3 custom SQL's , they are all same queries but due to some filter conditions , i need to separate them into 3 custom SQL's rather than a single Custom SQL,. Is it possible to Union these 3 custom SQLs in tableau Desktop? They are from the same database connection. Thanks
5 risposte
You can do the Union in your first Custom SQL script itself as shown below
SELECT A,B,C
FROM XYZ
WHERE Condition1
UNION ALL
SELECT A,B,C
FROM XYZ
WHERE Condition2
UNION ALL
SELECT A,B,C
FROM XYZ
WHERE Condition3
