How to convert Number to Text

[balasundaram]

I Have to convert 16 digit number into text.Because Csv&Excel supports only 15digit numeric number.

ex:-

4567321789012347(qlikview) this number coming  like 4567321789012340(csv&excel) . last digit coming ZERO

[tresesco]

Text()?

[ariel_klien]

Hi,

Did you try Text(Number_Field)

BR

Ariel

[#4]

If its the Qlik result you want use TEXT(NUMBERFIELD) AS TextNumField

[ashfaq_haseeb]

Hi

Try using num# function

num#(4567321789012347,'###########,###')

Or text function()

text(4567321789012347)

Both of them worked for me

Hope it helped.

Regards

ASHFAQ

[MK_QSL]

Text(YourNumberField) as YourNumberField

[its_anandrjs]

Use Text() function

Text(YourNumberField) as FieldName

[balasundaram]

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO

[balasundaram]

Yes..

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO

[balasundaram]

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO