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, 2019 in Tableau by Nithin
721 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, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

How to add same filter to multiple data sources in tableau server?

If numerous data sources have a field ...READ MORE

answered Apr 12, 2022 in Tableau by Neha
• 9,020 points
2,540 views
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 ffdfd
• 5,550 points
1,237 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 13, 2018 in Tableau by QueenBee
• 1,820 points
1,493 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
1,549 views
0 votes
1 answer

Getting incorrect tooltip while toggling through quick filter

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

answered Jun 27, 2018 in Tableau by ffdfd
• 5,550 points
805 views
0 votes
1 answer

Using Top in filter.

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

answered Apr 30, 2019 in Tableau by Cherukuri
• 33,030 points
680 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
9,952 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, 2019 in Tableau by Cherukuri
• 33,030 points
2,253 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, 2019 in Tableau by Cherukuri
• 33,030 points
838 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP