Creating manual and wildcard unions in Tableau Desktop to add additional rows of data
We use relationships to add additional fields to our data. For cases where we need to add additional rows from other tables or files, we use unions. We can union new data via manual union or wildcard union. We will look at both methods in the upcoming sections.
It is important to note that Tableau Desktop can create relationships and joins between tables, regardless of whether they are in the same database or across multiple databases (if the database supports cross-database joins). However, unions can only be created by tables in the same database. In the case of Microsoft Excel, this would mean the unions of multiple sheets within the same Excel workbook but not the ability to union across different workbooks.
Tableau Desktop can create unions across multiple text files. It is a common use case to get data dumps in the form of delimited files, which can then be joined together in Tableau...
