6 Replies Latest reply: Oct 24, 2016 5:32 AM by vineeta dahiya RSS

    Null Handling in Data Loading Script

    Mohammad Sarif

      Hi All,

       

      I have a date field Created_On at source. From source to QVD we are loading as it. Few records are NULL or Empty in Created_On. We need to implement such a logic so that Null fields will be populated as "Empty". Like below:

       

      if (Created_On = Null)

      then ("Empty")

      else

      (Created_On)

       

      Please suggest.

       

      Thanks in advance for your help.

      Sarif