1 Reply Latest reply: Apr 16, 2018 5:27 AM by Yvonne Klich RSS

    Handle NULL when LOAD multiple CSV

    adli sval

      I load 2 CSV files and I get many values of "-" (see image), which I guess means NULL (and that's fine). The reason, I guess, is because of missing values, which is also fine, because I want to see those missing values.

       

      THE PROBLEM is that I cannot filter only on those missing values, so I want to replace the missing values with a string like i.e. 'NULL'

       

      How can I do that? Here's what I tried (Qlik Sense version 3.2):

       

      NullAsValue *;

      Set NullValue = 'NULL';

      // set NullInterpret='';

      // SET NULLDISPLAY='NULL';

       

      LOAD

          "s-p-n",

          title as m_title

      FROM [lib://Other/mss-m.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);

       

      LOAD

          "s-p-n",

          "p-p-nr" as [s_p-p-n],

          e  as s_e,

          title as s_title

      FROM [lib://Other/mss-q.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);

       

      QS_Null.png