Remove row if two column are both empty

UserBird
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
Tagged:

Best Answer

  • AdrienL
    AdrienL Dataiker, Alpha Tester Posts: 196 Dataiker
    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

Setup Info
    Tags
      Help me…