Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Add new column

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

Labels (3)
1 Solution

Accepted Solutions
prma7799
Master III
Master III

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;

View solution in original post

2 Replies
tresesco
MVP
MVP

Try join like:

Load * From FirstTable;

Left Join

Load CountryCode, Country From YourExcel;

 

prma7799
Master III
Master III

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;