Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

Remove row if two column are both empty

Solved!
UserBird
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
1 Solution
AdrienL
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"))

View solution in original post

0 Kudos
4 Replies
Clément_Stenac
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
AdrienL
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"))

View solution in original post

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 (1)
A banner prompting to get Dataiku DSS