topic Re: Loading scientific values from CSV in QlikView

Loading scientific values from CSV

wizardo — Thu, 26 Nov 2015 11:07:57 GMT

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

Re: Loading scientific values from CSV

PrashantSangle — Thu, 26 Nov 2015 11:10:03 GMT

Hi,

use evaluate()

regards

Re: Loading scientific values from CSV

Thu, 26 Nov 2015 11:13:57 GMT

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

Re: Loading scientific values from CSV

Anonymous — Thu, 26 Nov 2015 11:27:17 GMT

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

text(YourFieldName) as YourFieldName

Re: Loading scientific values from CSV

wizardo — Thu, 26 Nov 2015 12:00:57 GMT

use evaluate() how?

can you give an example?

Thanks

Daniel

Re: Loading scientific values from CSV

swuehl — Thu, 26 Nov 2015 12:04:25 GMT

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.

Re: Loading scientific values from CSV

PrashantSangle — Fri, 27 Nov 2015 03:46:21 GMT

Hi,

like evaluate(fieldName)

for more details, read below article

Evaluate() Function‌

Regards