If a workbook uses data from more than one data source, you can blend data. Blending data is different from joining tables. It enables you to combine data from different sources. Tableau makes it very simple to perform this activity.
If you have more than one source of data, you can blend it together in Tableau. Alternatively, you might want to blend the data in a data warehouse or a data store in a single place, outside of the Tableau software.
Sometimes, when we put data together, we get an error message saying Fields cannot be used from the data source…. This means Tableau could not associate the new imported file with the existing file because it could not match any of the column names. This recipe will explain how to get around this issue.