Add new column

[Anonymous]

Hello qlikers 🙂 ,

I have a table, the name of the table is sales. 

The table looks like

CountryCode | Name | Amount | Price | Order

How you can see, I only have a CountryCode. I got a Excel File they looks like CountryCode | Country | .... | , for example JP | JAPAN | ....

How can I link the new table to the old?

It should looks like CountryCode | Country | Name | Amount | Price | Order.

Thank you in advance! 🙂

Sales:

Load * 

CountryCode

Name

Amount

Price

Order

[tresesco]

Try join like:

Load * From FirstTable;

Left Join

Load CountryCode, Country From YourExcel;

[prma7799 · Accepted solution]

Try with Mapping 

map1:

mapping LOAD *

Inline [

CountryCode , Country

JP, Japan

Dk, Denmark

No, Norway

] ;

Sales:

Load

CountryCode,

Name,

Amount,

Price,

Order,

ApplyMap('map1', CountryCode ,’NA') As Country

From table name;