Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Description
Returns the ISO-3166-1 country name from any country identification.
How does it work in the search window?
...
from my.upload.geolocation.data
select split(message, ";", 5) as countryCode
...
We want to get the ISO-3166-1 country names corresponding to the codes in our countryCode column, so we click Create column and select the ISO-3166-1 Country Name operation. Select countryCode as the argument and assign a name to the new column - let's call it countryName.
...
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 Name operation:
countryname(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, ";", 5) as countryCode select countryname(countryCode) as countryName |