Columns (transformations and filters only)
This tab lists the columns for the table you are working with. The table you are working with is the table you selected when you opened the Table Settings dialog box.
Expressions containing a condition for a NUMBER exceeding 19 digits are not valid. For example, the following expression is not valid:
case when $ID==12345678910111213149 then '1' else '0' end
When a column name contains special characters (for example, #pound), do the following:
-
Enable the Support special characters in column names used in expressions option in the task settings' Expression Defaults tab.
-
Use one of the following methods to add the column to the Build Expression pane:
-
Add the column directly from the Columns tab by double-clicking the column name. This is the recommended method.
-
Type the column name. If you choose this method, you must wrap the column name with quotation marks (for example, "#pound").
-