Using a sql expression in post filter

Nainish09

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

@Dataiku

Alexandru

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