4 Replies Latest reply: Sep 4, 2015 10:17 AM by youssef belloum RSS

    filtering missing values and insert a character string if the condition is met

      Hi guys, it's my first time here.

       

      here is my problem:

       

      I'm loading some fields in a dimension table:

       

      SQL SELECT

       

          Code as [% Commercial ID],

          Name as [Commercial name]

         

      FROM ...

       

      and the problem is that there are some missing values in the code field when I'm loading, resulting to this:

       

      test.png

      I just want to insert and display 'NA' for this case into my table. I don't know what I should use and how to use it between an If statement (into the load block) or a CASE (into sql block) ?

       

      Thank you