Facing some issues with Data Blending

Question

I have two tables: 1)The first one Which stores the countries in 2columns(country id INT & country name STRING)

2)second table where I keep the customer data including (country id INT & id of the user)

My plan is to present visually how many users I have per country by counting the id of the user, but I can't do the mapping of the country id.

Can someone help me to resolve it?

Answer 1

Hey Grim, 

First you use inner joins instead of blending so that you will have one final data source. After that change the type country name from string to Geographical role (Country/Region) in the data source tab. After you will be good to plot the data

Answer 2

Hey, if you are trying for 2 different sources (tables) then you can use join or data blending .

You can prefer to use joins as the tables have same field names, or else data blending.

If you are using data blending, check if you have the link connected ( RED COLOR ) to establish connection between the 2 tables, then try it will work

Or else it would show a warning message like this .(here sample - EU Superstore is my data source, if i try to use fields from 2 tables it would pop up a warning) 

so try again after connecting try again!!.

Hope this helps you.