create filter from multiple data sources

0 votes

I have multiple data sources that have city, state and country information.

Example -

Source 1:
ID      City        State       Country
12345   New York    New York    USA
12344   Cebu City               PHL
12232   Bengaluru   Karnataka   IND

Source 2:

ID      City    State    Country
12345   Dallas  Texas    USA
12344   London           UK

I would like to create a filter to show drill down option into country, state and city using both the databases. I cannot combine the source due to few sourcing issues. Not sure if a set can be created like union of the columns from the data sources to be able to show a filter that will have values from all the data sources.

Like..

Country = USA, PHL, IND, UK and then filter state and city and so on. 
Can someone please advise how I can achieve this? The city, state and country columns are dynamic in my data sources

Mar 13 in Tableau by Nithin
17 views

1 answer to this question.

0 votes
Hi Nithin,

1. You can perform full outer join on both the sources to get the country from both of them to apply filter. Join based on Country.

2. Now you would be able to drill down using country, state and city.

hope this helps you.
answered Mar 13 by Cherukuri
• 25,900 points

Related Questions In Tableau

0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by Atul
• 5,530 points
39 views
+2 votes
1 answer
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
49 views
0 votes
1 answer

How to split or divide the grouped data into multiple graphs?

One of a simple approach is to ...READ MORE

answered Apr 17, 2018 in Tableau by xyz
• 1,550 points
39 views
0 votes
1 answer

Is it possible to apply filter just to one of the measures

Hey @Ghost, Why don't you use Level of Detail ...READ MORE

answered Apr 17, 2018 in Tableau by Atul
• 10,240 points
33 views
0 votes
1 answer

Getting incorrect tooltip while toggling through quick filter

I think what you want to ask ...READ MORE

answered Jun 26, 2018 in Tableau by Atul
• 5,530 points
23 views
0 votes
1 answer

Using Top in filter.

Hi Tejas, The top filter is used to ...READ MORE

answered Apr 30 in Tableau by Cherukuri
• 25,900 points
20 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,819 views
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 25,900 points
57 views
0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1 in Tableau by Cherukuri
• 25,900 points
66 views