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 cleaning operation to specified columns in a table
Runs a named cleaning operation across one or more columns in a table. Currently supports the "cleandates" operation which normalises date values in the specified columns.
| Parameter | Description |
|---|---|
| cmd | Operation name (currently only "cleandates" is supported) |
| Argument 0 | Table name containing the columns to clean |
| Argument 1 | CSV list of column names to apply the cleaning operation to |
| Argument 2 | CSV list of primary key column names used to identify rows |
CleanColumns "Operation name (currently only "cleandates" is supported)", "Table name containing the columns to clean", "CSV list of column names to apply the cleaning operation to", "CSV list of primary key column names used to identify rows"