Remove row if two column are both empty

UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
in Using Dataiku
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:
· Share on Facebook

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"))
    · Share on Facebook

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered, Moderator Posts: 754 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
    · Share on Facebook
  • SimonM
    SimonM Registered Posts: 7 ✭✭✭✭

    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?

    · Share on Facebook
  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭

    Is called Filter row/cells with formula

    · Share on Facebook
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…