topic Re: Importing Excel File with Longitude and Latitude help in QlikView

Importing Excel File with Longitude and Latitude help

Fri, 18 Jan 2013 11:49:59 GMT

HI,

Im trying to import an Excel file with Longitude and Latitude but when I run the import script the '.' are converted into ',' (comma's). How can I keep the format of the these fields?

This is my import script :

LOAD

lat,

lng,

Item

FROM

C:\uk_test.xlsx

(ooxml, embedded labels, table is uk_test);

Many thanks for any help!

Fiorano

Re: Importing Excel File with Longitude and Latitude help

Fri, 18 Jan 2013 11:57:09 GMT

hi,

change environment varibale DecimalSep to '.'.

SET DecimalSep=',';

replace above statement with with below one

SET DecimalSep='.';

Niranjan M.

Re: Importing Excel File with Longitude and Latitude help

jagan — Fri, 18 Jan 2013 12:02:20 GMT

HI,

Try like this

LOAD

Text(lat) AS lat,

Text(lng) AS lng,

Item

FROM

C:\uk_test.xlsx

(ooxml, embedded labels, table is uk_test);

Regards,

Jagan.

Re: Importing Excel File with Longitude and Latitude help

Fri, 18 Jan 2013 12:12:47 GMT

Hi I tried this and the latitude figures are now showing as single figures : '5'

Fiorano