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")




      Please suggest.


      Thanks in advance for your help.