Description:
Add a composite table’s fields to a table sequence or a cursor according to the latter’s key values.
Syntax:
T.derive(A/cs,x:C,…;wi,...)
Note:
The function adds one or more fields of composite table T to table sequence A or cursor/multicursor cs according to the latter’s key, which should be in the same order as the existing fields of T. . It returns a table sequence when adding fields to a table sequence; and returns a cursor, which will be sorted by T’s dimension or key. when adding fields to an ordinary cursor or a multicursor.
Parameters:
T |
A composite table |
A/cs |
A table sequence/cursor/multicursor |
x |
Field value |
C |
Column alias;can be absent |
wi |
Filtering condition; separate multiple conditions, which should be met at the same time, by comma(s). |
Options:
@z |
Match existing fields in A/cs with T’s dimension or key |
Return value:
A table sequence/cursor
Example: