The Derive statement is used to generate derived fields based on a field definition created with a Declare statement. You can either specify which data fields to derive fields for, or derive them explicitly or implicitly based on field tags.
Syntax:
Derive [Field[s]] From [Field[s]] field_list Using definition
Derive [Field[s]] From Explicit [Tag[s]] tag_list Using definition
Derive [Field[s]] From Implicit [Tag[s]] Using definition
Arguments:
| Argument | Description |
|---|---|
| definition |
Name of the field definition to use when deriving fields. Example: Calendar |
| field_list |
A comma separated list of data fields from which the derived fields should be generated, based on the field definition. The data fields should be fields you have already loaded in the script. Example: OrderDate, ShippingDate |
| tag_list |
A comma separated list of tags. Derived fields will be generated for all data fields with any of the listed tags. Example: '$date' See: Field tags |
Examples:
-
Derive fields for specific data fields.
In this case we specify the OrderDate and ShippingDate fields.
DERIVE FIELDS FROM FIELDS OrderDate,ShippingDate USING Calendar; -
Derive fields for all fields with a specific tag.
In this case we derive fields based on Calendar for all fields with a $date tag.
DERIVE FIELDS FROM EXPLICIT TAGS '$date' USING Calendar; -
Derive fields for all fields with the field definition tag.
In this case we derive fields for all data fields with the same tag as the Calendar field definition, which in this case is $date.
DERIVE FIELDS FROM IMPLICIT TAG USING Calendar;
See: Derived fields (full example)
Learn more
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!