How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

[#1]

Hi,

Is there a way to convert Customer Addresses (House No, Street Name, Post Code) into Latitude and Longitude Co-ordinates?

Any suggestion would be much appreciated. (There are close to 20,000 addresses).

Regards

Arun

[#2 · Accepted solution]

Hi,

You can see the attaches files,

Its reed from xls File the Address and transfer it to Latitude and Longitude ,

Its very usefull for me.

Hope it helps.

Yigal.

[#3]

Hi Yigel,

That's exactly what I wanted.

Thanks!

Arun Raj

[Anonymous]

Hi Yigel,

when i try and run your QVW it says error in downloading content. can you please provide an updated version taking into account some changes google maps might have made to not let the old file work.

Thanks

Gareth

[#5]

Hi, I am sorry, I am new in Qlik sense and do not know how to run it. How can I rewrite my script?

LOAD

NAME,

ADDRESS;

[TABLE1]:

SELECT

"NAME",

"ADDRESS"

FROM "XY"."TABLE1";

Address form is: Tigergasse 7, Vienna, 1080