numeric variable in alphanumeric

[#1]

Hi,

I have a question:

from a database field numbers (like 2, 0) and importing it into qvw if the first digit is a number ,

becomes 1 instead of 01 or 2 instead of 02 ... etc. ..

My solution when I do the load:

Repeat ('0 ', 2 - Len (Text (Num # (Variable, '00')))) & Text (Num # (Variable, '00')) as variable1;

ok ...

ok ... the "text" and "num" are not going well in this case

There is a more "simple"?

Thanks

[#2]

Hi William,

ia´m not sure if i understand your question correctly.

But this works for me:

Num

((

(

Be aware that the NUM function only works to 13 or 14 digits.

You can use in cases like this EVALUATE but without decimals.

See the attached file as an example for this.

Rainer

Numbers, '000000') as NewNumbers

[#3]

Sorry,

I mean:
I have a numeric variable containing:

01
02
03
04
...

importing into QlikView me becomes:

1
2
3
4

whereas I would like him to stay:

01
02
03
04

but withe command text or num not like...

Thanks

[#4]

Try it

ArticoliNew:
Noconcatenate
LOAD text(CODICE) as CODICE,
DESART
resident Articoli;

Daniela

[#5]

I already tried

Text (variable)

but since the variable is defined numeric, text has no effect ..

[#6 · Accepted solution]

left('00',2-len(Variable)) & Variable as Variable1

not quite the most elegant solution, but it's a bit more simple.