Referring to Columns

Top  Previous  Next

 

 Everywhere in Spatial Studio where you can refer to a column from your data, it is done as an expression; You can choose just one column or you can add two columns together, refer to linked columns in other layers etc. and much more:

 

SCRIPT~1_img7

 

 You can type in your expression and drop down to choose the columns in the column box:

 

SCRIPT~1_img8

 

Or you can open the script editor window by clicking in the column box and then pressing ctrl P:

 

SCRIPT~1_img9

 

 In the Script Editor you can type in your expression and choose your columns with Insert Column. Furthermore, you can save out and load scripts. There is full intelligent code completion capability as well as error highlighting and tooltips on code elements and errors.

 

 To bring up code completion on initial items that you are typing in, press ctrl space bar; for example, as I type in ‘Ro’ I can press ctrl space bar and code completion comes up giving me options to choose from:

 

SCRIPT~1_img10

 

As I continue typing in code completion continues being prompted:

 

SCRIPT~1_img11

 

In this example here I am writing an expression to get the area of the elements in my Zones layer, this will then display as text labels:

 

SCRIPT~1_img12

 

SCRIPT~1_img13

 

SCRIPT~1_img14