Survey banner
Share your feedback on the Dataiku documentation with this 5 min survey. Thanks! TAKE THE SURVEY

Using a sql expression in post filter

Nainish09
Level 2
Using a sql expression in post filter

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.

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

@Dataiku 

0 Kudos
1 Reply
AlexT
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.
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. 

Thanks

0 Kudos