- in (case sensitive): This operator is used for numbers and for alphabets(if you would like to qualify them in the same case as you have mentioned). For example, if you have written Apple and the receipt has apple, then this would not qualify.
- in (case insensitive): This operator is used for alphabets only for now. If you would try to use this for numbers, the qualifier will not work. For alphabets, it would not matter in what format you have provided the word, it will still qualify.
The option "IN" is used when there are multiple values inside the connecting field. Example: Item IDs 1001, 1002, 1003, etc.
The options for "IS" (case in/sensitive) should be selected when there is only one value in the connecting field. Example: Menu Name is Entree, Quantity is 1, etc.