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. 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
|
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.