Add ability to compare one field to another in field mapping and custom routing
Currently we can compare an incoming field to a defined string. It would be really helpful to be able to compare an incoming field to another incoming field to build decision logic into either the field mapping or into custom routing. For example, I may want to enter a purchase a particular way if the billing and shipping addresses are different, and either enter differently or route to omit those if they are the same.
I could also use this for data cleanup. I could create a separate column with expected information for each subset of data in my spreadsheet, and then compare against that list. Example: I'm updating the annual giving tiers so I pull the current listing in custom fields as well as total giving for the year. I add a column with what that tier should be (or perhaps use the replace function with the giving summary), compare to the current tier and exclude those that already match.