Mastering Tableau 2018.1, Second Edition 4.3: Combining Your Data with Union

What is the primary purpose of using Union in data merging?

• To delete duplicate data entries

• To combine multiple data sources for comprehensive analysis

• To create a backup of data

• To encrypt data for security

In the first scenario, how are two tables from a single data source combined?

• By using a drag-and-drop method to create a Union

• By manually entering data into a new table

• By exporting data to a new file

• By using a third-party software

What happens to the number of rows when a Union is created with duplicated data?

• The number of rows is halved

• The number of rows remains the same

• The number of rows is reduced by one

• The number of rows is multiplied by two

What types of files are mentioned as examples for merging in the second scenario?

• Image files and video files

• Text files and HTML files

• Excel workbooks and CSV files

• PDF and Word documents

What is the role of wildcard characters in the second scenario?

• To create a backup of data

• To identify specific worksheets and workbooks

• To delete unwanted data

• To encrypt data for security

How can you confirm the data merge in Tableau?

• By comparing with the original data

• By reviewing the path added to each row

• By checking the number of columns

• By exporting the data to a new file

What is the next step after merging data in Tableau, as mentioned in the video?

• Encrypting the data for security

• Creating charts and visualizations

• Exporting data to a PDF

• Deleting unnecessary data