ErrorMessage

Description

Converts error messages found in a field into strings. 

Use this function to select a field that may contain errors. A new field is created by the function which contains the error messages as a string data type. Data from the selected field which did not produce an error are written as <null> values.

Use

  • Select a field. (Any)
  • Enter the Output field name.

Example

You are checking for error messages in the endsWith field.

The function checks for error messages in the endsWith field. A new field is created named Extracted error message and contains the error message texts as a string value.


Type

Formulas