FieldValue - script and chart function
FieldValue() returns the value found in position elem_no of the field field_name (by load order).
Syntax:
FieldValue(field_name , elem_no)
Return data type: dual
Arguments:
Argument | Description |
---|---|
|
Name of the field for which the value is required. For example, the column in a table. Must be given as a string value. This means that the field name must be enclosed by single quotes. |
|
The position (element) number of the field,following the load order, that the value is returned for. This could correspond to the row in a table, but it depends on the order in which the elements (rows) are loaded. |
Limitations:
If elem_no is larger than the number
of field values,
Examples and results:
The following examples use the field: First name from the tableNames.
Examples | Results |
---|---|
Add the example data to your app and run it. |
The table |
Chart function: In a table containing the dimension |
|
FieldValue('First name','1') |
|
FieldValue('First name','7') |
|
Script function: Given the table |
|
John1: Load FieldValue('First name',1) as MyPos1 Resident Names; |
MyPos1=John, because ' |
Peter1: Load FieldValue('First name',7) as MyPos2 Resident Names; |
MyPo2s= - (Null), because there are only 6 values in the First namefield. |
Data used in example:
Names:
LOAD * inline [
First name|Last name|Initials|Has cellphone
John|Anderson|JA|Yes
Sue|Brown|SB|Yes
Mark|Carr|MC |No
Peter|Devonshire|PD|No
Jane|Elliot|JE|Yes
Peter|Franc|PF|Yes ] (delimiter is '|');
John1:
Load FieldValue('First name',1) as MyPos1
Resident Names;
Peter1:
Load FieldValue('First name',7) as MyPos2
Resident Names;