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.

Precision

Specify the number of digits allowed to compose the value (including fractional part).

Scale

Specify the number of digits in fractional part.

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!