Try your hand at analyzing royal sentiment in Dataiku DSS! Learn more

Remove row if two column are both empty

Dataiker
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
4 Replies
Dataiker
Dataiker
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
0 Kudos
Dataiker
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
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
Dataiker
Dataiker

Is called Filter row/cells with formula

Labels (1)