Derive

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. The list of tags should be enclosed by round brackets.

Example: ('$date','$timestamp')

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;

Derived fields (full example)

See also:

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?