Transform your first file

Create a new field from a calculation.

Source → Transform → Destination

Add the operation

Add Transform from Components, then click Add transformation.

Under Fields, choose Compute column.

Enter an Expression and an Output column. The output name must not already exist.

The saved operation appears in the list:

Simple mode

Simple expressions allow + - * / ( ), numbers, and existing field names.

shape_area * 100

into area.

Another common case is converting square metres to hectares:

shape_area / 10000

into hectares.

Expression mode

Use Expression mode for comparisons, AND / OR, and a small function list. This is not a SQL console — you cannot write SELECT.

population / area_km2

See Expression syntax for the full list.

For spatial SQL or queries Basic operations cannot express, use Transform with SQL.

See also

• Convert your first file
• Transform data
• Filter rows
• Expression syntax