Sampling methods

Ankur5289
Ankur5289 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 Partner

Hi ,

I want to see my data based on more than one value belonging to a column.

For example the only conditions that we can use filtering in sampling is attached in the document.

Can we have something which we use in SQL like "IN".

for example the capability now is :

COUNTRY="INDIA" OR %INDIA% ( By using contains)

how to we filter data using this condition:

COUNTRY IN ("INDIA","RUSSIA", "SPAIN")

So how to see data with multiple values inside a column? any ways how to filter this data?

Tagged:

Best Answer

  • EliasH
    EliasH Dataiker, Registered Posts: 34 Dataiker
    Answer ✓

    Hi @Ankur5289
    ,

    You should be able to accomplish this by first by changing the "Keep only rows that satisfy" field to "at least one of the following conditions" and then including multiple "contains" conditions to satisfy your filter.

    Something like:

    Screen Shot 2021-10-25 at 10.51.50 AM.png

Answers

Setup Info
    Tags
      Help me…