LogChanges

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

Key	Value(s)	Description
method	"LogChanges"	Logs summary changes between the values of 2 fields.
fromField	"InputFieldName"	Required. Input Field Name. Must be discrete.
toField	"OutputFieldName"	Required. Output Field Name. Must be discrete.
project	"CurrentProjectName"	Current Project Name

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.