LogChanges

Compares and Logs summary changes between the values of 2 fields.

Use this method to obtain summary data about changes in values.  

{
  "method": "StartErrorLog",
  "filename": "ScriptLog_%DSTAMP%",
  "mailTo": [
    "me@email.com"
  ],
  "project": "Test1"
}

{
  "method": "LogChanges",
  "fromField": "customer.gender-code",
  "toField": "customer.gender",
  "project": "Test1"
}

• LogChanges can only be called on Discrete Fields.
• To view the output from LogChanges, see the Log tab in Script Editor.
• To capture output from LogChanges in a more persistent format, set up Script Logging using StartErrorLog.
• A more systematic form of LogChanges can be achieved using ETLSummaryFromTable or ETLSummaryFromTableEx

Example Output

LogChanges customer.occupation -> customer.modified-occupation

Rows Processed : 14
Rows Changed : 4
Rows Kept : 10

"junior programmer" -> "junior coder" : 1,262,462
"lead programmer" -> "lead coder" : 561,282
"programmer" -> "coder" : 2,735,469
"senior programmer" -> "senior coder" : 1,750,315

See Replace Function for example use.