Use Case for Tableau Union introduced in Tableau 9.3

During my Corporate Tableau Training in Gurgaon , i get questions many time regarding Unions in Tableau . You can find a similiar question on Tableau Community -

https://community.tableau.com/message/523550#523550

For Corporate training and Online Training contact at info@instrovate.com

 

Tableau 10.0 Beta version talked about wildcard union in Tableau 10.0. However, the official release of Tableau 10.0 does not have the wild card Union. Tableau 10.0 “Union” has the same union functionality that was introduced in Tableau 9.3. So probably we can expect wildcard union in the future version of Tableau 10.x release.

Use Case for Tableau Union introduced in Tableau 9.3

 

So Today we would like to Quickly go through a use case explaining the “Union” introduced in Tableau 9.3. Once again we take the “Sample Super Store” data set and make changes accordingly so as to understand the concept. The Reason we always take “Sample Super Store” to explain the concept is, everyone is familiar with the data set so we do not waste our time exploring and explaining the Data.

In order to understand “Union” in the easiest way, let us consider the scenario that rather than having all the Customer related Order data in “Orders” tab of sample Super store, say we have multiple sheets containing the details about the Orders of each customer.

For e.g.  the below excel has different sheet with the name of customers and the different sheets contains the details about the Customers.  So the Data is not all present in one file rather the data is split into Little files and you need to do the analysis. Tableau Union helps you to piece together data that has been split into little files.

  First Sheet contains “Orders Data for Customer Aaron Bergman”

[ akriti.lal@TechnicalJockey.com ]

 

Second sheet contains “Orders” data for customer “Aaron Hawkins”.

 

Now in such scenario, if we want to do the analysis on complete data set , Union comes as a Handy tool introduced in Tableau 9.3

Once you connect to Super Store Customer Data from Tableau 10.0 , you will have the below screen

You cannot create a Join here because it is the same Data for different customers. So Before Tableau 9.3, you would have to copy and paste all the related Customer Data in a single excel sheet to do your analysis. But now you can just use the “union” and drag and drop all the different sheets to do your analysis.

So Double Click on “New Union” and using shift button select all the customer orders data and drag it to the Union window

 

 

Click on “Ok” and now you will have Data from all the different customer excel sheet at one place to do your analysis.

One more thing that needs to be noted here is at the end of all the columns, you can see a column that Tableau created “Table Name”, this essentially contains the name of the file from which each row originated.


 

So Now you can go to your worksheet and do your analysis as if this was one single file without any copy paste workaround.

 

Write a comment

Comments

  • Prasanthi.B (Thursday, August 25 16 11:19 pm EDT)

    Thanks for posting akriti these are very helpful to me to learn more.Please keep on posting.

Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail