Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having this issue, I am loading a column with 20 digits '60000000098634125780' and QV is getting it as a string but I need it to be recognized as a number.
I have tried num#(column) and it stills get it as a string and if I use the num() function it does not convert any value just drop them and leave them null.
What would you recommend to do?
Thank you for your time.
Ryu,
Try evaluate() when reading in the field in your script:
LOAD
evaluate(FIELD) as FIELD,
...
FROM ...;
That's too many digits to make a number from. QV supports 14 digits. Beyond that it will stay text.
Try evaluate() when reading in the field in your script:
LOAD
evaluate(FIELD) as FIELD,
...
FROM ...;
HI,
Try this
=Num(60000000098634125780)
I am getting this as result 6.0000000098634e+019
Regards,
Jagan.
Try num(num#(column) )..
really thanks!
i don't know why but i couldn't suppress zeros (for example from '00000000232') with the num function, but using evaluating i could obtein it (for example 232)
that worked out for me! thanks!