Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all, I have a problem sending data to GMAPS
On latitude formula, I obtain null on formula and null on the example
longitude * ((256*pow(2,$(var_zoom)))/360)
I'm testing with the example
This is data on table
| latitude | longitude | Country | Population |
|---|---|---|---|
| 41.153332 | 20.168331 | Albania | 3600523 |
And this is the obtaines value
| Country | longitude | latitude | =longitude * ((256*pow(2,1))/360) |
|---|---|---|---|
| Albania | 20.168331 | 41.153332 | - |
Can someone help me?
This is the complete table
| Country | longitude | latitude | Population | Country //Pop-up text |
|---|---|---|---|---|
| Albania | 3600523 | Albania | ||
| Algeria | 33858000 | Algeria | ||
| Argentina | 40301927 | Argentina | ||
| Armenia | 3230100 | Armenia | ||
| Australia | 21446187 | Australia | ||
| Austria | 8340924 | Austria | ||
| Azerbaijan | 8629900 | Azerbaijan | ||
| Bahrain | 760168 | Bahrain |
The load inline:
LOAD * INLINE [
Country,Population,GDP_PPP_M, latitude, longitude
Albania, 3600523, 19621, 41.153332, 20.168331
Algeria, 33858000, 269201, 28.033886, 1.659626
Argentina, 40301927, 523169, -38.416097, -63.616672
Armenia, 3230100, 17139, 40.069099, 45.038189
Australia, 21446187, 760800, -25.274398, 133.775136
Austria, 8340924, 317800, 47.516231, 14.550072
Azerbaijan, 8629900, 64082, 40.143105, 47.576927
Bahrain, 760168, 24245, 25.930414, 50.637772
];
I think it's just an issue with the decimal format
In the script, change the comma in point
SET DecimalSep='.'
regards
jj
But then, It changes on all numbers into the project.
Is any way to do only on longitude / latitude
Thanks
Maybe you can have multiple SET DecimalSep
SET DecimalSep = ',' ;
others data
...
SET DecimalSep = '.' ;
only for long / lat
....
SET DecimalSep = ',' ;
regards
JJ