Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

segerchr
New Contributor III

Load skript Value instead of load value

Hey,

i am searching for a function which can do the following for me:

load

ACB.Name,

ACB.Number --> (if Number 1 is loaded, please write One in the database, if Number 2 is loaded please write Two.

from Sheet

Maybe somebody could help. Thanks in advance. CS

1 Solution

Accepted Solutions
Luminary
Luminary

Re: Load skript Value instead of load value

Hi,

the only way I can think of is using a reference table which you would join or map to your source table:

Map_NumString:

Mapping LOAD * Inline [

   Num, String

   1, One

   2, Two

   3, Three

];

Table1:

LOAD

   ACB.Name,

   ApplyMap('Map_NumString', ACB.Number)     as NumberString

from Source;

Hope this helps.

Juraj

1 Reply
Luminary
Luminary

Re: Load skript Value instead of load value

Hi,

the only way I can think of is using a reference table which you would join or map to your source table:

Map_NumString:

Mapping LOAD * Inline [

   Num, String

   1, One

   2, Two

   3, Three

];

Table1:

LOAD

   ACB.Name,

   ApplyMap('Map_NumString', ACB.Number)     as NumberString

from Source;

Hope this helps.

Juraj