Remove \N when exporting as CSV

I've noticed when exporting datasets as csv all null fields are filled with \N.

 

Is there anyway to remove this by default?

Best Answer

  • Unknown
    Accepted Answer

    One option as a Beast Mode fix for limited fields, would be to use a case statment to assign the null fields a value.

    Example:

     

    CASE 
    WHEN `(column name)` IS NULL THEN 1

    ELSE 0

     

    At the DataFlow level, you could replace NULL values with empty text strings, and then create a similar Beast Mode as above to filter out all empty text or NULL values from the Columns.

     

Answers