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.
Compare TEXT/ENDTEXT SQL output to an existing table and write difference rows as transactions
Executes the collected SQL and compares the result set against the specified target table, then inserts rows that represent the differences as transaction records. Use for incremental data-sync scenarios where only changed rows should be recorded.
| Parameter | Description |
|---|---|
| cmd | Target table name to compare against |
| Argument 0 | Group-by units field name |
| Argument 1 | Last end date for the comparison window |
| Argument 2 | Optional WHERE clause to filter the comparison |
ExecuteTransactionDifference "Target table name to compare against", "Group-by units field name", "Last end date for the comparison window", "Optional WHERE clause to filter the comparison"