Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Try join like:
Load * From FirstTable;
Left Join
Load CountryCode, Country From YourExcel;
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;