Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
when i upload the attached excel file on Qlikview, i would like convert the second column SSCC to number.
even if sometime we can see a value of "????" in this column (we should ignore)
thanks
try this in load script ..
Num(Evaluate(SSCC),'#0') as SSCC,
thanks but unfortunately it doesnt work
May be just:
Evaluate(SSCC) as SSCCNum
?
If you need to exclude other values, you could try like:
load
Evaluate(SSCC) as SSCC
From <> where IsNum(Evaluate(SSCC));
Did Lisa's last reply solve your problem? If so, please be sure to return to your post and use the Accept as Solution button on Lisa's last post to give her credit for the assistance and let other Community Members know this addressed your problem. If you require further assistance, please leave an update for us.
Regards,
Brett
Hi Ahmedwank,
why not simply ask if SSCC is numeric?
Like this:
T1:
LOAD N?,
If(IsNum(SSCC), SSCC) as SSCC
FROM
[C:\Users\Burkhard\Desktop\Kopie von ZPS2 1-9-19 au 15-9-19.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Then no values of SSCC with ???? are loaded.
Hope this helps.
Burkhard