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
    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.



    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.