Transformations and Filters
Click the Transformations and Filters tab to show the Expression defaults tab. Expressions can be used in global transformations and filter rules as well as in table-level transformations and filters.
This option can be set globally for all tasks or individually for a specific task. To set the option for a specific task, click the Change to Task Policy button and set the option as required. If you want to use the global policy set in the server settings'Transformations and Filters tab, click the Change to Global Policy button.
- Support special characters in column names used in expressions: Enable this option if you want to include source column names with special characters in expressions defined for this task. An example of such a column name would be special#column.
Before enabling this option, you must fix any use of double quotes in string literals. For example, a transformation such as:
CASE age WHEN age < 18 THEN "adult" ELSE "minor" END)
must be rewritten as:
CASE age WHEN age < 18 THEN 'adult' ELSE 'minor' END)