Please enable JavaScript to view this site.

Returns the dictionary cell value in the specified column at the row with the attached key.

 

string Dictionary(string dictionaryName; string key; string columnName)

 

dictionaryName

The name of the dictionary to read data from.

key

The key to match when selecting the row in the dictionary.

columnName

The name of the column to read data from.

Example

Dictionary("City"; "Gothenburg"; "Latitude")

Read the column "Latitude" from the dictionary "City" at the row with the key "Gothenburg". The answer might be "57.71".

Remarks

Dictionaries can also be read using direct references without calling the Dictionary() method. The above example is then written:
 

City["Gothenburg"; City.Latitude]
 
The advantage with using the Dictionary() method is that both which dictionary and which column to read can be parametric.

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC