Remove \N when exporting as CSV

anafziger
anafziger
edited March 13 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?

- Austin, Major DOMO @ 42 North Rx

Best Answer

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

  • KaLin
    KaLin

    Does anyone have an answer for anafziger ?

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

     

Categories