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 trailing LIKE pattern matching
Same as ApplyDataMappingLike but appends a trailing % to the mapping pattern before the LIKE comparison, so a pattern "HP" will match "HP LaserJet 4000" in the source field. Use this when the mapping source values are prefixes rather than full wildcard patterns.
| 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 prefix 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 |
ApplyDataMappingLike2 "Table name to update", "Column in the table to update with the mapped value", "Column in DataMapping to use as the prefix 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"