This content has been marked as final. Show 4 replies
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]
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) ?