| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Description
Returns the ISO-3166-1 country latitude from any country identification.
How does it work in the search window?
This operation needs only one argument:
Argument | Data type |
|---|---|
Country mandatory | string |
The data type of the new column is float.
Example
...
| Rw ui textbox macro | ||
|---|---|---|
| ||
The examples in this article use values in a data table generated from the following CSV file. |
...
If you want to try the example |
...
for yourself, download the file and upload it to your domain by clicking |
...
Data upload |
...
in the navigation |
...
panel. Name the new |
...
table |
...
and select Current date |
...
as Date parsing type. Learn more about uploading data in Uploading log files. After receiving the confirmation message, you can access the table |
...
from the |
...
Finder, selecting my → upload → geolocation → data. When you upload data from a file, all the information is included in a single column |
...
called message. To split the values into different columns, you can use |
...
the Split operation. Click Toggle Query Editor in the search window toolbar and paste the following LINQ query to save time:
|
We want to get the ISO-3166-1 latitudes corresponding to the countries in our countryName column, so we click Create column and select the ISO-3166-1 Country Latitude operation. Select countryName as the argument and assign a name to the new column - let's call it countryLatitude.
...
Use the operator select... as... and add the operation syntax to create the new column. This is the syntax of the ISO-3166-1 Country Latitude operation:
countrylatitude(string)
Example
...
Note that you must have
...
uploaded the following CSV file
...
to your Devo domain as explained above to try out this example.
| Ui button | ||||
|---|---|---|---|---|
|
Copy the following LINQ script and try the above example on the my.upload.geolocation.data table.
| Code Block |
|---|
from my.upload.geolocation.data select split(message, ";", 4) as countryName select countrylatitude(countryName) as countryLatitude |