7 Replies Latest reply: Jul 24, 2012 2:48 PM by David Nelson RSS

    Conditional Inline Mapping in Load Script?

      I have a field "add_date", which is a timestamp field in the database (date/time). Is there a way to create an inline table that designates any date older than 14 days as "Past Due" and those that are not as "On Track"?

       

      Something along the lines of this for a true/false field, maybe?

       

       

      LOAD

       

      * INLINE
      [
      add_date, idle_request
      '{>Today()-14}','1'
      '{<Today()-14}','0'
      ]

      ;