Loading scientific values from CSV

[wizardo]

Hi,

i have a csv with values in scientific notation, for example:   5.15062E+12

qhwn i open this CSV in EXCEL and change the cell format to Number i get this value: 5150615600780

which is the correct value

but when i load the CSV file into qlikview it loads in the E+ format 5.15062E+12

and when i change it to number in the object properties NUMBERS tab

it shows this:5150620000000

how can i load it so it shows the correct value like in excel: 5150615600780

thanks

Daniel

[PrashantSangle]

Hi,

use evaluate()

regards

[#3]

Can u upload the .csv file with few data rows so that I can check.

[Anonymous]

use text() at script while loading from Excel into QV and then convert it into number, like:

text(YourFieldName) as YourFieldName

[wizardo]

use evaluate() how?

can you give an example?

Thanks

Daniel

[swuehl]

Daniel,

if your csv file really shows values like

5.15062E+12

I doubt that there are any means to get a higher precision using any tool (even Excel).

Either your file format is not a text file showing above text value, but containing some numeric representation also, or the excel formatting is screwed up.

[PrashantSangle]

Hi,

like evaluate(fieldName)

for more details, read below article

Evaluate() Function‌

Regards