| 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?
...
from my.upload.geolocation.dataselect split(message, ";", 2) as continentName
...
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.
| View file | ||
|---|---|---|
|
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 |