Description
...
Argument | Data type |
|---|---|
geocoord mandatory | geocoord |
latitude / Grid size mandatory | float / integer |
longitude mandatory | float |
The data type of the new column is geocoord.
...
from my.upload.sample.dataselect split(message, ";", 08) as geocoordStrings
...
We want to represent the strings in the geocoordStrings column in the format :type:value. First, we must transform the strings to data type geocoord.
Step 1: Transform the geocoord strings into data type geocoord
...
gridlatlon(geocoord, latitude_float, longitude_float)gridlatlon(geocoord, grid_size_integer)
Example
Copy the following LINQ script and try the above example on the my.upload.sample.data table.
|
...