Remove row if two column are both empty

Solved!
UserBird
Dataiker
Remove row if two column are both empty
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
0 Kudos
1 Solution
AdrienL
Dataiker
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"))

View solution in original post

0 Kudos
4 Replies
Clรฉment_Stenac
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
AdrienL
Dataiker
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"))
0 Kudos
SimonM
Level 2

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?

0 Kudos
Liev
Dataiker Alumni

Is called Filter row/cells with formula

Labels

?
Labels (1)
A banner prompting to get Dataiku