filter or split the dataset.

prash_
Level 3
filter or split the dataset.

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 Kudos
2 Replies
CatalinaS
Dataiker

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

 

!contains(colA, "text")

 

 

prash_
Level 3
Author

Thank you @CatalinaS  

0 Kudos