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.
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:
|
To rename the processor, click the Edit icon that is displayed when hovering over the default name of the processor.
To edit its description, click the Edit icon that is displayed when hovering over Description.