Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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