Map city to country in qliksense table

[qlikuser22]

Hi. 

I have a table with Empno, name, amount, year, country and city. I have loaded all the data from the SQL database. I have the cities in my database. I want the corresponding country to be mapped in the table. I don't have the country details in my table. Is there any way to map the countries automatically to its respective cities.  

Example: 

EMPNO  NAME  AMOUNT   YEAR   COUNTRY     CITY

123           aaa        3000            2018        -              Mumbai

124           bbb       4000               2017      -             Dallas 

I want the country to be displayed by mapping as India and USA.

Any help. 

[Qlik1_User1]

@qlikuser22 ,

There are two options

1- Add a table from SQL having country data and using apply Map you can add countries automatically to country column.

Second option is only applicable when you don't have country table in SQL.

2- Create Inline "Country" table for each city and again use  apply Map you can add countries automatically to country column.

Hope this helps.