Name | Occupation | Bank account balance |
Rey | Scavenger | $600 |
Poe | Pilot | $30,000 |
Kylo | Unemployed | $0 |
A union of these tables would give a single table containing the rows of each individual table:
Name | Occupation | Bank account balance |
Luke | Farmer | $2,000 |
Leia | Princess | $50,000 |
Han | Smuggler | -$20,000 |
Watto | Junk Dealer | $9,000 |
Darth Maul | Face Painter | $10,000 |
Jar Jar | Sith Lord | -$100,000 |
Rey | Scavenger | $600 |
Poe | Pilot | $30,000 |
Kylo | Unemployed | $0 |
Tableau allows you to union together tables from file-based data sources, including the following:
- Text files (.csv, .txt, and so on)
- Sheets (tabs) within Excel documents
- Subtables within an Excel sheet
- Multiple Excel documents (Tableau 10)
- Google Sheets (Tableau 10)