How to achieve the below union in tableau? Below M1,D1,S1 and A1 are 4 different tables in Oracle and have different set of columns not the same column set. I have M1,D1,S1,A1 excels with me and want to club all srnum,itnum,mrnum,prnum into one column as possible in oracle but how to achieve the same in tableau? SELECT srnum AS ALLNUM FROM M1 UNION ALL SELECT "itnum" AS ALLNUM FROM D1 UNION ALL SELECT mrnum AS ALLNUM FROM S1 UNION ALL SELECT prnum AS ALLNUM FROM A1
Thanks for the video!
Good Explaination. Thank you
How to achieve the below union in tableau? Below M1,D1,S1 and A1 are 4 different tables in Oracle and have different set of columns not the same column set. I have M1,D1,S1,A1 excels with me and want to club all srnum,itnum,mrnum,prnum into one column as possible in oracle but how to achieve the same in tableau?
SELECT srnum AS ALLNUM FROM M1
UNION ALL
SELECT "itnum" AS ALLNUM FROM D1
UNION ALL
SELECT mrnum AS ALLNUM FROM S1
UNION ALL
SELECT prnum AS ALLNUM FROM A1
Can we say union is like append...?
My live and extraction option is not showing
Can we do only in Tableau Prep or with Tableau desktop?