Tables sorted by name and by population

GuiXT
// clear existing tables
Clear V[cities*]

// create table variable
CreateTable V[cities] city latitude longitude country countrycode population

// load content from .csv file
CopyText fromFile="C:\temp\cities.csv" toText="cities"
CopyText fromText="cities" toTable=V[cities] delimiter=";"

// sort by name
Sort V[cities] orderBy="city"

// display city table
Table (2,2) (16,104) name="cities" fixedColumns=6 _
  title="&V[cities.rowcount] cities"

Column "CC" size=3 name="countrycode"
Column "City" size=30 name="city"
Column "Country" size=30 name="country"
Column "Population" size=12 name="population"
Column "Latitude" size=10 name="latitude"
Column "Longitude" size=10 name="longitude"

Offset (15,0)

// duplicate table for new sorting, as tables are rendered after processing
CreateTable V[citiesSorted] include=V[cities]
Set V[citiesSorted] "&V[cities]"

// sort by population
Sort V[citiesSorted] orderBy="population" -descending

// display sorted city table
Table (2,2) (16,104) name="citiesSorted" fixedColumns=6 _
  title="&V[citiesSorted.rowcount] sorted cities"

Column "CC" size=3 name="countrycode"
Column "City" size=30 name="city"
Column "Country" size=30 name="country"
Column "Population" size=12 name="population"
Column "Latitude" size=10 name="latitude"
Column "Longitude" size=10 name="longitude"