Skip to main content Skip to complementary content

SQL expression processor

Writes the result of a custom SQL expression in a new column.

The SQL expression processor lets you write simple or complex SQL expressions to process data in a new column of your source dataset.

SQL expression properties

Properties to configure to create a new column and apply SQL expressions on it.

Configuration
Property Configuration

Name

Enter the name of the new column on which the SQL expression will be applied.

Type

Select the data type of the column.

Depending on which data type you select you may also need to set more column properties, for example, Precision, Scale, or Length.

Nullable Select if you want the column to be nullable.

SQL expression

Either enter a simple SQL expression in the text box, or click Expression builder icon to open the expression builder. In the expression builder, you can:

  • Enter complex SQL expressions in the Build expression text box. You can select the column names on the left panel to auto-complete your expression.

  • Extract all parameters used in the SQL expression in the Extract parameters area, and test them with custom values.

  • Test your SQLexpression in the Test expression area.

To rename the processor, click the EditEdit icon that is displayed when hovering over the default name of the processor.

To edit its description, click the EditEdit icon that is displayed when hovering over Description.

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!