topic associate a string to a number in QlikView

associate a string to a number

Thu, 05 Sep 2013 09:42:57 GMT

Hi everyone,

I get data in form of numbers.I have to assign a string to it.

Thanks,

Asmita

Thu, 05 Sep 2013 10:20:50 GMT

try text(fieldname) function

swuehl — Thu, 05 Sep 2013 10:23:49 GMT

Your requirement is still somwhat unclear, an example always helps to understand.

You can look into conditional functions to assign strings to your numbers when loading in, or look into a Mapping approach:

LOAD Number,

if(Number = 1, 'One',

if(Number = 10, 'Ten',

if(Number = 100, 'Hundred')

)

) as NumberText

FROM ....;

NumberMap:

MAPPING LOAD * INLINE [

F1, F2

1, One

10, Ten

100, Hundred

];

LOAD Number,

applymap('NumberMap', Number) as NumberText

FROM ...;

Thu, 05 Sep 2013 12:22:51 GMT

Thanks,

The if loop worked