Add Default Translation for a Particular Field

[Anonymous]

Hi
I am loading a text file with the below columns.

Name,Address,Connection

ABC,Toronto,1

XYZ,LA,2

Translations for Connection is 

1-GSM

2-PSTN

How can i define the translations by default for this field in Qlikview so that when i use this field in Straight Table, i get the translation instead of numbers.

Thanks

Taher

[rwunderlich]

You can define a mapping table and Map Using statement before you load the table. 

ConnectionMap:
Mapping Load * Inline [
Code, Value
1,GSM
2,PSTN
];

Map Connection Using ConnectionMap:

 // Load your text file 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com