csv load: Can't read numbers in exponential form

Wed, 25 Nov 2020 16:16:04 GMT

I am trying to load datasets from CSV file as follows:

TAB1:

LOAD Name,

Score,

Address

FROM (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Now lets say for following sample structure of Dataset.csv, TAB1.Scores field in Qlikview is not being resolved into 68587640. It is because CSV has this field stored as 6.86E+07.

Name	Score	Address
John	1109342	NewYork
James	6.86E+07	Ohio

I tried to do following: Num(Score, '(dec)')

and Num#(Score, '(dec)')

But to no avail.

I cannot control how CSV files are generated. Is there a way to overcome this in Qlikview (For example, typecast in Qlikview, etc.)

Thanks

Rahul

Re: csv load: Can't read numbers in exponential form

Sat, 28 May 2016 18:31:04 GMT

Hi Guys

Anybody who can help here.

Thanks for your time.

Rahul

topic csv load: Can't read numbers in exponential form in QlikView

csv load: Can't read numbers in exponential form

Re: csv load: Can't read numbers in exponential form