Numeric to Text

Thu, 02 Sep 2010 11:32:26 GMT

Hi community,

Please i want to transform a field INTEGER to a field STRING in Load statement?

For example : Let take this script.

Ligne:
LOAD CodeLigne,
LibelleLigne,
NumLigne,
CodeSsSousGroupe,
CodeSousGroupe,
CodeGroupe
FROM
Structure_Edition_V02.xls
(biff, embedded labels, table is Ligne$);

The type of field NumLigne is INTEGER,

I want to transform it in STRING.

How to do???

Thanks.

Numeric to Text

Miguel_Angel_Baeyens — Thu, 02 Sep 2010 11:40:35 GMT

Hello Yimen,

Use Text() function. In the following example

Text('000001') AS TextField, Num(000001) AS NumField

TextField will return all preceding zeroes, as the field is considered text, while NumField will return just "1", as preceding zeroes don't count.

Hope that helps

topic Numeric to Text in QlikView

Numeric to Text

Numeric to Text