KNOWLEDGE BASE

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
Did this article resolve the issue?