4 Replies Latest reply on Jan 27, 2019 2:39 PM by Sandeep Varma

    Multiple Unions in Tableau

    Sandeep Varma

      Hi, I am looking to avoid this in SQL and include in Tableau, Is their any way: SELECT 'I' AS A, 'SUCCESS' AS B, NVL(TO_CHAR(SUM(CNT)),'0') AS C FROM METRICS WHERE SALES_TYPE = 'Retail' UNION SELECT 'J' AS A, 'NONIVRT' AS B, NVL(TO_CHAR(SUM(CNT)),'0') AS C FROM METRICS_NON WHERE SALES_TYPE = 'Online' UNION SELECT 'K' AS A, 'NONITy' AS B, NVL(TO_CHAR(SUM(CNT)),'0') AS C FROM METRICS_SALE WHERE TYPE = 'Buy'