Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Text()?
Hi,
Did you try Text(Number_Field)
BR
Ariel
If its the Qlik result you want use TEXT(NUMBERFIELD) AS TextNumField
Hi
Try using num# function
num#(4567321789012347,'###########,###')
Or text function()
text(4567321789012347)
Both of them worked for me
Hope it helped.
Regards
ASHFAQ
Text(YourNumberField) as YourNumberField
Use Text() function
Text(YourNumberField) as FieldName
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
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
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