Remove rows that have null value?

Marco_13112001

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?

Josh Boxer

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

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

Thanks, it makes more sense now.

Josh Boxer

Hi Marco

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

Marco_13112001

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.