Which of the following situations describe the best reason to use a union?

The correct answer is A. You have two tables with similarly named columns of data that you want to combine. A union in Tableau is best used when you have two or more tables with similarly named columns that you want to combine by stacking them vertically (adding rows). This is useful when you have separate tables with the same structure (e.g., monthly sales data in different files)…

Connecting to & Preparing Data

Question

Options

AYou have two tables with similarly named columns of data that you want to combine.
BYou have two data sets with similar data types for which you want to find only distinct values.
CYou have two tables with differently named columns of data that you want to combine.
DYou have two data sets saved in different formats that you want to unify into a single format.

How the community answered

(34 responses)

A
79% (27)
B
3% (1)
C
12% (4)
D
6% (2)

Explanation

A union in Tableau is best used when you have two or more tables with similarly named columns that you want to combine by stacking them vertically (adding rows). This is useful when you have separate tables with the same structure (e.g., monthly sales data in different files) and want to consolidate them into one table. Options involving distinct values, differently named columns, or different formats do not directly align with the purpose of a union.

Topics

#union#data combination#columns#tables

Community Discussion

No community discussion yet for this question.

Full TDS-C01 Practice