Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

csv load: Can't read numbers in exponential form

Hi


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.


   

NameScoreAddress
John1109342NewYork
James6.86E+07Ohio

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

1 Reply
Not applicable
Author

Hi Guys

Anybody who can help here.

Thanks for your time.

Rahul