Remove \N when exporting as CSV

anafziger
anafziger Member
edited March 2023 in Datasets

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.

    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

  • Does anyone have an answer for anafziger ?

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

    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.