Compare Values Between Two or More Fields

We’ve added two new functions to the Transform Data module to help you compare values across two fields to determine whether the values are the same or different:

• Compare: Is Equal? (Exact), which searches for an exact match,
• Compare: Is Equal? (Related), which ignores capitalization differences and spaces before or after.

For example, you could use the Compare: Is Equal? function to check the First and Last Name fields for unhelpful data, such as someone entering their first name in both fields, like “Joe Joe”. If the values are the same, you could have Insycle clear the last name value.

Learn more about these functions and how to use them in the Compare: Look for Matching Values in Two Fields section of the Transform Data Function Catalog.