AX1136
On this page
Updating data in the temptable based on another column
To update data in the temptable based on another column, create a transform step that uses the built-in function Update temp column. This function updates a column in the temptable from a specified column in another table, using the given match key. For example, this function would typically be used to look up the credit reversal sign from the Account table.
Function parameters
Parameter | Description |
---|---|
Temp table column |
The name of the column in the temptable to be updated. |
Source column |
The name of the column to use to update the temptable. Fully qualified Table.Column syntax must be used. |
Match columns |
The columns to use to match data to update, in the format For example: |
Temp table filter |
Optional. A filter used in the SQL WHERE clause against the temptable, to identify rows to update. If omitted, all matching rows are updated. Fully qualified Table.Column syntax must be used. The temptable must be represented as a variable. For example: NOTE: If a temp table column uses a database reserved word (such as "Key") then in the filter you must place that column in double quotation marks and use all upper-case letters. Use of database reserved words should be avoided whenever possible. |
Get more information and training resources: www.kaufmanhall.com |
Was this topic helpful? Send us feedback. update_temp_column.htm |
