| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Description
Returns the ISO-3166-1 alpha-2 continent name from any continent identification.
How does it work in the search window?
This operation needs only one argument:
Argument | Data type |
|---|---|
Continent 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 names corresponding to the continent codes in our continentCode column, so we click Create column and select the ISO-3166-1 Continent Name operation. Select continentCode as the argument and assign a name to the new column - let's call it continentnameAlpha2.
...
Use the operator select... as... and add the operation syntax to create the new column. This is the syntax of the ISO-3166-1 Continent Name operation:
continentname(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, ";", 3) as continentCode select continentname(continentCode) as continentnameAlpha2 |