Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I want to filter my data based on certain codes like '1876', '09A1', '9873' etc.
So, while using Post Filter in Stack recipe either I wanted to use formula or sql expression to only filter the data having these codes. How can I do it?
In attached Image, there is the interface.
In SQL expression I have tried one expression that was "PROCEDURE_CODE" IN ('1876', '09A1', '9873', 'B897', '905A')
But this expression showed me error of Invalid expression "IN".
Hi @Nainish09,
You should be able to use the form directly in the post-filter with "Is any of the strings" and set the values you want.
This should translate to SQL if you have SQL datasets and use a SQL engine.
Thanks
โ