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.
Expand and normalise word tokens in a table column using SQL-driven rules
Reads rows from the source query, applies word-expansion rules to the specified field, and writes the expanded values to the output field using the update SQL. Optionally pre-processes word data and applies a nice-name flag. Used to standardise software publisher or product names during import.
| Parameter | Description |
|---|---|
| cmd | SQL to get the data |
| Argument 0 | SQL to update the data |
| Argument 1 | Field name to expand |
| Argument 2 | Field to output to |
| Argument 3 | SQL to preprocess the word data |
| Argument 4 | SQL to get the word data |
| Argument 5 | Nice name flag |
TableWordExpand "SQL to get the data", "SQL to update the data", "Field name to expand", "Field to output to", "SQL to preprocess the word data", "SQL to get the word data", "Nice name flag"