1 Reply Latest reply: Aug 6, 2010 7:37 PM by John Witherspoon RSS

    How can I assign a 'n/a' text value to NULLs in my data set?

      I created a mapping table as follows:


      Grade Description

      A: Great
      B: Good
      C: Bad

      However, I also have Grades such as 'D' and 'E'. Using this mapping table returns NULLs when I create a table with the results. Is there a way in the script I can have non-mapped Grades to say 'n/a'? I'm thinking of an IF function but maybe there is a better way. Thanks!