3 Replies Latest reply: Aug 8, 2015 11:47 AM by Stefan Wühl RSS

    Setting a default value on a column within a load statement

    Kurt Schramm

      Hi.  I want to be able to set a default to the "Partner" column if it is null in the attributes QVD.  How is that accomplished within the load statements?  If it's blank or null, I want to populate it with "Other".  Thank you in advance. 

       

      Left Join

      LOAD
      HPROP  as HMY,
      SUBGROUP9  as Partner
      FROM   $(vPathQVD)Attributes.qvd (qvd);