The Tester and TestFilter transformers have five distinct Comparison Modes:
- Automatic
- Numeric
- Case Sensitive
- Case Insensitive
- Date/Time
As well as the option to Specify Per Test.
The FeatureJoiner and FeatureMerger transformers have three Comparison Modes:
- Automatic
- String (presumably the same as Case Sensitive, above, but I have not validated that and don’t see it specified in the documentation)
- Numeric
And the way that these transformers are designed, they are inherently “Per Test” or per “Join On” condition, as it were.
The general Idea here is to make the Comparison Modes more consistent across transformers - there are likely other transformers that could be included in this, beyond the four mentioned above.
- Case Sensitive, Case Insensitive, and Date/Time could be useful in the Feature-type transformers, in addition to the Test-type transformers. There are other ways to achieve these, of course, but there may be value in having them readily available.
- The order in which Comparison Modes are listed could be consistent - this is a minor point.
If the various types of Comparison Modes are already tailored to best match each class of transformer, then the idea may not have merit, but posing it in case others could see any value in the proposed change or a similar change.