Geocoding returns wrong latitude and longitude

[#1]

Hi all,

I have a table with only a column with a number of zipcodes.

I agreed with the customer that:

- if length zipcode = 5 => 'France'

- if length zipcode = 4 => 'Belgium'.

If there is an incorrect zipcode, Google should return 'ZERO_RESULTS' as GeoCode Status.

For the zipcodes in Belgium,  this is working correct. However for the zipcodes in France, Google returns geo-date from locations in the US.

I would like to know how I can have a reliable result from Google?

See QVW in the attachment.

Kind regards,

Fien

[#2]

This one works CSV 2 Geo Data

It allows you to specify country also as part of the address.

It should clear the issues.

regards