Ready for Dataiku 10? Try out the Crash Course on new features!GET STARTED

Sampling methods

Solved!
Ankur5289
Level 3
Level 3
Sampling methods

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?

 

 

0 Kudos
1 Solution
EliasH
Dataiker
Dataiker

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

View solution in original post

0 Kudos
2 Replies
EliasH
Dataiker
Dataiker

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

View solution in original post

0 Kudos
Ankur5289
Level 3
Level 3
Author

Thanks @EliasH  for the help. It solves the issue

0 Kudos

Labels

?
Labels (1)
A banner prompting to get Dataiku DSS