Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Tableau Exam TDS-C01 Topic 12 Question 23 Discussion

Actual exam question for Tableau's TDS-C01 exam
Question #: 23
Topic #: 12
[All TDS-C01 Questions]

When field names in the Union do not match, then:

Show Suggested Answer Hide Answer
Suggested Answer: D

By default, both field names are present in the Union, but contain several null values!

When field names in the union do not match, fields in the union contain null values.You can merge the non-matching fields into a single field using the merge option to remove the null values.When you use the merge option, the original fields are replaced by a new field that displays thefirstnon-null value for each row in the non-matching fields.

You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are 'May2016,' 'June2016,' and 'July2016.'

A union of these tables creates the following single table that contains all rows from all tables.

Now suppose a fourth table, 'August2016', is added to the underlying data. Instead of the standard 'Customer' field name, it contains an abbreviated version called 'Cust.'


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel