Merge Mismatched Fields With Certain Patterns After Wildcard Union in Tableau Desktop

Published: 21 Feb 2022
Last Modified Date: 23 Feb 2022

Question

How to automatically merge the fields with different names after wildcard union in Tableau Desktop?
e.g. fields that match a certain pattern will be automatically merged together (like 2022*)

For example, manually merging the fields with different names after wildcard union works well.
User-added image

However, after another CSV file was added by the wildcard union, another mismatched field appears.
User-added image

How to automatically merge the fields with different names after wildcard union.

Environment

Tableau Desktop

Answer

The ability to automatically merge the fields with different names is not currently built into Tableau Desktop.
Please consider the following workaround options.

Option 1:

Manually merge the mismatched fields after the files in the wildcard union have changed.

Option 2:

Rename the fields in data sources, so that the merging fields have one single name.
In the example below, the field names should be changed to [date].
User-added image