filter or split the dataset.

prash_ Registered Posts: 17 ✭

April 2023 in Using Dataiku

I need to split a dataset based and tow condition

1) colA is not null

2)colA is not contain

in formula i can see isNotNull but im not getting any option for is not contain how to do that?

0 · Share on FacebookShare on Twitter

Answers

• 

  Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker

  April 2023 edited July 17

  If colA from your dataset contains strings, you can use a formula like below to filter the data:

  !contains(colA, "text")

  1 · Share on FacebookShare on Twitter
• 

  prash_ Registered Posts: 17 ✭

  April 2023

  Thank you @CatalinaS
  

  0 · Share on FacebookShare on Twitter