7 Replies Latest reply: Jul 19, 2016 10:53 AM by Robert Fishel RSS

    SUM IF with a date in LOAD Script

    Robert Fishel

      Hello everyone.  I am having trouble getting the syntax right in my load script.  Here is what I have:

       

      SUM(IF(SO_AD_SEG_MET.w_prd_dt='2016-04-01',SO_AD_SEG_MET.metric_value)) AS test

       

      What is wrong with this syntax, please?