Using a sql expression in post filter

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

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

Answers

  • Alexandru
    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.
    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

Setup Info
    Tags
      Help me…