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

    Youssef Belloum

      Hi guys, it's my first time here.


      here is my problem:


      I'm loading some fields in a dimension table:




          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:



      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