AX1136

Updating data in the temp table based on another column

To update data in the temp table based on another column, create a transform step that uses the built-in function Update temp column. This function updates a column in the temp table 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 temp table to be updated.
Source column	The name of the column to use to update the temp table. Fully qualified Table.Column syntax must be used.
Match columns	The columns to use to match data to update, in the format `TempColName = SourceColName`. Separate multiple match sets with commas. For example: `ACCT = ACCT, DEPT = DEPT`
Temp table filter	Optional. A filter used in the SQL WHERE clause against the temp table, to identify rows to update. If omitted, all matching rows are updated. Fully qualified Table.Column syntax must be used. The temp table must be represented as a variable. For example: `{temptable}.ACCT > 20000` 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.