FindChangedFields

FindChangedFieldsFunction

Compares two tables and identifies differences at the field level.

Syntax

FindChangedFields (table FirstTable, table SecondTable, vector MatchFields, vector CompareField1,CompareField2...)

Arguments

Argument	Description
table FirstTable	A table of the entries to be compared
table SecondTable	Second table of the entries to be compared
Vector Match fields	Array of the columns on which the two tables are to be matched>
Vector CompareField1,CompareField2...	Columns that need to be compared

Examples:

FindChangedFields([[FusionTestTable]],[[FusionTestTable2]],Array('IntColumn'),'PhoneNumCol')

Compares FusionTestTable and FusionTestTable2 tables by matching the rows on intColumn and identifies changes in PhoneNumberCol.