topic Re: Convert number to string in QlikView

Convert number to string

richard_chilvers — Wed, 27 Nov 2013 12:09:24 GMT

I am loading a table where a key field (for linking with other tables) may be just numeric or may be alphanumeric.

eg. 12345

or 1A345

As it is LOADed, the field is therefore interpreted as a number or a field.

I want to force the field to always be a string field, for convenience.

Please propose the best way of achieving this.

Thanks

Richard

Re: Convert number to string

richard_chilvers — Wed, 27 Nov 2013 12:10:43 GMT

Sorry .... please see correction below

As it is LOADed, the field is therefore interpreted as a number or a string.

Re: Convert number to string

kaushiknsolanki — Wed, 27 Nov 2013 12:10:46 GMT

Hi,

Use the Text() function.

Load Text(FIeld) as New_Field

From xyz;

Regards,

Kaushik Solanki

Re: Convert number to string

Wed, 27 Nov 2013 12:14:32 GMT

Text(fieldname) use for convert number into text

num(fieldname) use for convert into number

Re: Convert number to string

MayilVahanan — Wed, 27 Nov 2013 12:31:38 GMT

Try with Text() function, resolve ur problem.

which convert num to string.

Re: Convert number to string

richard_chilvers — Wed, 27 Nov 2013 14:14:14 GMT

Thanks !

I guessed there would be an easy answer, but for some reason I thought the TEXT() function would fail on a string field

Re: Convert number to string

Tue, 10 Feb 2015 06:44:53 GMT

Thanks dude..this thread save me a lof of time..

Re: Convert number to string

Ken_Thomas — Mon, 17 Dec 2018 16:40:34 GMT

There is a knowledge article relate to this that is important to be aware of:
Leading zeros are missing in loaded data values
https://qliksupport.force.com/articles/000003759

When leading zeros exist in the data load, the behavior can seem odd with leading zeros added sometimes and removed sometimes. This article explains the behavior and gives a workaround if different behavior is needed.