Skip to main content

NEST

Nest all currently defined fields into one sub-struct.

Syntax​

NEST identifier

Parameters​

  • identifier - The field name to create for the nested structure

Description​

The NEST command takes all currently defined fields and nests them into one sub-struct by creating a new field containing a struct. All original fields are preserved as properties of the nested struct. This operation is the inverse of UNNEST.

  • UNNEST - Lifts struct fields into the parent or enclosing result set (inverse operation)