We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Apply a data mapping lookup to update a field in a temporary table
Joins the specified table to the DataMapping table using an exact match and updates a target field with the mapped value. The mapping type is identified by name. An optional WHERE clause can restrict which rows are updated.
| Parameter | Description |
|---|---|
| cmd | Table name to update |
| Argument 0 | Field in the table to update with the mapped value |
| Argument 1 | Source field name in the DataMapping table to match against (typically SourceValue1) |
| Argument 2 | Field in the table whose value is used for the lookup join |
| Argument 3 | Target field name in the DataMapping table that provides the replacement value (typically TargetValue1) |
| Argument 4 | DataMappingType name to scope the lookup |
| Argument 5 | Optional additional WHERE clause to restrict the rows updated |
ApplyDataMapping "Table name to update", "Field in the table to update with the mapped value", "Source field name in the DataMapping table to match against (typically SourceValue1)", "Field in the table whose value is used for the lookup join", "Target field name in the DataMapping table that provides the replacement value (typically TargetValue1)", "DataMappingType name to scope the lookup", "Optional additional WHERE clause to restrict the rows updated"