Hello,
The screenshot below illustrates my solution for this question.
Compare two columns (Category and Class) and detect if the Class entered is in the right Category
I thought that this works fine, but found a wrong result when the comparison mode for the IN operator was set to Automatic.
The result will be correct shown as following If you set Case Sensitive or Case Insensitive to the Comparison Mode, but I believe that Automatic mode must return the correct result as well.
I suspect there could be a potential bug here. Could you please take a closer look at this?
(FME 2019.1.2 build 19630)