Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Tried the evaluate()
LOAD id,
evaluate(iccid) as iccid_complete,
date,
cost,
data;
[stream]:
SELECT id,
iccid,
`date`,
cost,
data
FROM ebdb.stream;
The result is this:
@mvtriff , I think its returning the value based on the values passed(in your case 'iccid').
https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...
Evaluate will round off the number, so it won't be the original one. If you need to maintain all the digits, I'd suggest reading the value as text rather than numeric.