convert to number 2

[ahmedwank]

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

[Lisa_P]

try this in load script ..

Num(Evaluate(SSCC),'#0') as SSCC,

[ahmedwank]

thanks but unfortunately it doesnt work

[tresesco]

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));

[Brett_Bleess]

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

[veidlburkhard]

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