EMPTYRECORD ER function

The EMPTYRECORD function returns a null Container (record) value that has the same structure as the specified record list or record.

Syntax

EMPTYRECORD (list)

Arguments

list: Record list or Container (record)

The valid path of a data source of either the Record list or Container (record) type.

Return values

Container (record)

The resulting record value.

Usage notes

Note

A null record is a record where all fields have an empty value. An empty value is 0 (zero) for numbers, an empty string for strings, and so on.

Example

EMPTYRECORD (SPLIT ("abc", 1)) returns a new empty record that has the same structure as the list that is returned by the SPLIT function. For more information, see SPLIT.

Additional resources

Record functions