Survey banner
The Dataiku Community is moving to a new home! New posts are now disabled and the community will shortly be in temporary read only mode: LEARN MORE

Using a sql expression in post filter

Level 2
Using a sql expression in post filter


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.

Screenshot 2023-03-29 145134.png


 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".


0 Kudos
1 Reply

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.
Screen Shot 2023-03-31 at 11.00.01 AM.png

This should translate to SQL if you have SQL datasets and use a SQL engine. 


0 Kudos