Using union
In this recipe, we will combine a number of comma separated value (CSV) files into a single data set in Tableau.
Getting ready
To follow this recipe, download the business license files from the City of Vancouver's website from http://data.vancouver.ca/datacatalogue/businessLicence.htm:
Download the CSV version, and save all the files in a local directory in your computer:
How to do it...
Here are the steps to prepare the data files:
- Click on New Data Source icon and connect to
business_licenses.csvwhich contains the most recent year's records: ...
Get Tableau 10 Business Intelligence Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
