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 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 Edit Edit icon that is displayed when hovering over the default name of the processor.

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

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!