Using a sql expression in post filter
Nainish09
Registered Posts: 7 ✭
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".
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker
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