
Tables sorted by name and by population
// 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"