1 of 1 people found this helpful
As far as I can understand, you are blending the data in your workbook.
In order to filter across all 4 data sources you have 2 options:
1. Create a single data source by joining on the common field and bring it into Tableau;
2. Create a 'region' column for all the data sets and join by country, zip, AND region.
Tableau probably can't find 1 to 1 relationship in your data, and because of this it can not filter across all data sources.
In any case, I suggest using an ETL tool to create a dataset in a correct structure before you can bring it into Tableau. Tableau is a fantastic tool, but it has limited data preparation capabilities at the moment.
Hope this helps!
Hey Olga, thank you! and I think this is what I was afraid of
I don't know how to create an ETL tool so I will have to find a work around with this, thank you once again for your suggestions!
By saying 'use an ETL tool' I meant a software tool that would help you to get data in the right format like Alteryx, Analytics Canvas, etc.
If I were you, I'd create a reference table with unique country, zip code and region combinations from data source 4. Then I'd add join this reference table with data sources 1-3. Finally, I'd join it back with data source 4 and write everything into a TDE.
Zip code has a lower granularity than region and country, so it is possible to do what you want to do. It just requires a little bit of data preparation.
Hope this helps!
Excellent, thank you for your help and suggestions Olga!
Hope you are doing well
Jose R. Alvarenga
Global Business Development
The University of Texas MD Anderson Cancer Center
(O): 713.834.9893 | (F): 713.563.0003