I have two separate tables with different lists of countries in each. I need to create filter pane using Country field from Master table (I have attached the example), but I also want to create a bar chart from Table 1 to respond to the Country filter.
Moreover, as you can see, the names of the countries are not the same, for example: 'UK' in Master table and 'United Kingdom' in Table 1.
Both lists of the countries need to be loaded. Bar chart which is using data from Table 1, should display countries from Table 1, but need to be responsive to Country filter which is using data from Master table.