Thanks for the extremely swift reply! This is the first time I've heard of Tableau Prep, I will explore this and see if it solves my problem. I know traditionally Tableau Desktop has UNION capabilities but it is only possible for specific tables in the DB. for my UNION I need to first query multiple tables together first, and then UNION.
Anyways, I will take a look at Tableau Prep.
I appreciate your help.
Great. tableau Prep is a new tool by Tableau launched around April and it provides opportunity to shape data nad make it ready for Tableau. Download it and try it for your specific problem