| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Description
Returns the ISO-3166-1 alpha-2 continent code from any continent 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 string.
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 alpha-2 continent codes corresponding to the continent names in our continentName column, so we click Create column and select the ISO-3166-1 Continent Alpha-2 Code operation. Select continentName as the argument and assign a name to the new column - let's call it continentalpha2.
...
Use the operator select... as... and add the operation syntax to create the new column. The syntax is as follows:
continentalpha2(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, ";", 2) as continentName select continentalpha2(continentName) as continentalpha2 |