Remove rows that have null value?

Options
Marco_13112001
Marco_13112001 Member
edited December 2023 in General

I'm creating a dataset from a snapshot and I would like to remove rows that have null value on a specific column. Any suggestions?

Best Answers

  • Josh Boxer
    Josh Boxer Administrator
    Answer ✓

    There is a Function call 'IsNull' that you should select from the list of default functions

    image.png
    1. select the column you are filtering, such as Email
    2. click 'Is' (next to Null) so that it changes to 'Not'
    3. [Optional] 'Preview' to confirm true is being returned for most rows and false for the null rows
    4. Apply


    Regarding the If then else Function, if you want to use it in future, it always goes at the end/right of whatever you are building, example function from the function library

  • Marco_13112001
    Marco_13112001 Member
    Answer ✓

    Thanks, it makes more sense now.

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Hi Marco

    Would adding a Filter step before the Snapshot step work to filter out the unwanted rows before they are written?

  • Marco_13112001
    Marco_13112001 Member

    Hi Josh,

    That's was my idea as well. However, when adding the filter step I'm not sure what should be the next step i.e. an IF-ELSE function o something else. I've tried the IF-ELSE but could not make it work.

Categories