Replace NULL

You'll see 'NULL' appear in column cells from time to time, when there is no data or no matching data available. 

You can replace these 'NULL' cells with data from other columns or with other information in two ways:

1. Via the column header:

if_null.gif

2. Via the query steps:

  • Go to add a new column and click the + button
  • Enter the following formula: if ( mycolumn.isNull() ) then "no info" else "mycolumn", replacing 'mycolumn' with the name of your column.

Screenshot_2023-05-02_at_11.18.07.png

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.