1 Reply Latest reply: Feb 18, 2015 1:05 AM by 濱野 正樹 RSS

    Help me with script error

      Hi

       

      I am facing Field not found - <Date Received>

       

      when write the code :

       

      QUALIFY     "Date Sent",

          "To (address)",

          [Date Received],

          "From (address)" ;

       

       

       

       

      [Inbox]:

      LOAD

      IF (match(LEFT(Subject,3),'RE:', 'Re:', 're:','rE:'),MID(Subject,4),Subject)

      as Subject,

          "Date Sent",

          "To (address)",

          [Date Received],

          "From (address)"

      ;

      LOAD

          Subject,

          "Date Sent",

          "To (address)",

          date(date#("Date Received", 'mm/dd/yyyy hh:mm')) as [Date Received],

          "From (address)"

      FROM [lib://Data/Deloitte_inbox.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

       

      UNQUALIFY;

       

       

       

       

      [MIN_INBOX]:

      LOAD

          Subject,

          min([Date Received] ) as [First Time Received]

      RESIDENT [Inbox]

      GROUP BY

          Subject ;