Remove row if two column are both empty
![UserBird](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar12.png)
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
Hi,
I would like to know if this is possible :
I want to remove row only if two column are empty.
So I use the script "Remove rows where cell is empty"
Column single | multiple | pattern | all
How to use the multiple?
Regards
I would like to know if this is possible :
I want to remove row only if two column are empty.
So I use the script "Remove rows where cell is empty"
Column single | multiple | pattern | all
How to use the multiple?
Regards
Tagged:
Best Answer
-
Hi,
You can use the processor named "Remove rows/cells with formula", which can remove rows when a given formula is true. In the formula, you can use something like:
isBlank(strval("col1")) && isBlank(strval("col2"))
Answers
-
Hi,
Multiple allows you to remove columns from a list, checking for each of them whether it is empty.
For your use case, I would recommend:
* Concatenate the two columns
* Remove rows where the concatenation is empty -
I would like to do this in DSS 7 but I can't find the "Remove rows/cells with formula" - has this been deprecated? If so, how would I achieve this now?
-
Is called Filter row/cells with formula