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 to a table using LIKE pattern matching
Updates rows in a table by joining to the DataMapping table using a SQL LIKE match. The source field value in the table is compared against the mapping pattern field using LIKE, and the target field is updated with the mapped value. Use this when data mapping source values contain wildcards (e.g. "HP*").
| Parameter | Description |
|---|---|
| cmd | Table name to update |
| Argument 0 | Column in the table to update with the mapped value |
| Argument 1 | Column in DataMapping to use as the LIKE pattern (e.g. SourceValue1) |
| Argument 2 | Column in the table whose value is matched against the pattern |
| Argument 3 | Column in DataMapping holding the replacement value (e.g. TargetValue1) |
| Argument 4 | DataMappingType name to filter by |
| Argument 5 | Optional extra WHERE clause to restrict which rows are updated |
ApplyDataMappingLike "Table name to update", "Column in the table to update with the mapped value", "Column in DataMapping to use as the LIKE pattern (e.g. SourceValue1)", "Column in the table whose value is matched against the pattern", "Column in DataMapping holding the replacement value (e.g. TargetValue1)", "DataMappingType name to filter by", "Optional extra WHERE clause to restrict which rows are updated"