Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I want to create a GeoPoint with the function GeoMakePoint(). However, this does not work because my Latitude and Longitude fields are of type Text or Dual. I cannot figure out why some values are Text and others are Dual as this seems to be random. I tried converting the Longitude and Latitude fields to numbers without success. I tried the following:
Attached is a QVD (see screenshot) with sample data. I created an extra column with my expected result. I created this column by using the following:
'[' & Longitude & ',' & Latitude & ']' as GeoPoint_Expected
This partially works in the map object, but it still gives me an error that some data points cannot be shown.
Does anyone know what the solution?
hard to diganose. but did you try trim and check there are trailing spaces by any chance?
Also are the rows which gets tagged as rows the format the same as others?
I just tried the function Trim() but there are no leading spaces. The Text and Dual records both have "visually" same format, so I cannot notice any difference.
I came up with this same problem and I found that by doing this to the lat/long fields worked
Num#(Latitude, '#', ',') as Latitude,
Num#(Longitude, '#', ',') as Longitude
I would suggest doing the above in the temp table with your postcodes and then do a select from the table table and use the GeoMakePoint function
GeoMakePoint(Latitude, Longitude)
Like I said this seemed to work for me 🙂
Thanks