Learning Tableau 2019 - Third Edition

Union files together

Often, you may have multiple individual files or tables that, together, represent the entire set of data. For example, you might have a process that creates a new monthly data dump as a new text file in a certain directory. Or, you might have an Excel file where data for each department is contained in a separate sheet.

A union is a concatenation of data tables which brings together rows of each table into a single data source. For example, consider the following three tables of data:

Originals:

Name	Occupation	Bank account balance
Luke	Farmer	$2,000
Leia	Princess	$50,000
Han	Smuggler	-$20,000

Prequels:

Name	Occupation	Bank account balance
Watto	Junk Dealer	$9,000 ...