filter or split the dataset.
Options
prash_
Registered Posts: 17 ✭
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?
Answers
-
If colA from your dataset contains strings, you can use a formula like below to filter the data:
!contains(colA, "text")
-
Thank you @CatalinaS
