topic Re: Add Default Translation for a Particular Field in QlikView

Add Default Translation for a Particular Field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Add Default Translation for a Particular Field

rwunderlich — Tue, 04 Dec 2018 03:00:47 GMT

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