6 Replies Latest reply: Mar 4, 2013 4:56 AM by Perumal Ayyappan RSS

    Missing/Misplaced FROM error message

      Hi,

       

      I don't know where is the issue in the following script, which causes an error message, about a missing/misplaced FROM.

      It relates to the part starting at [New Table].

      The first load runs fine.

       

      Thanks!

       

       

      [StatusLog]:
      LOAD [Case ID],
      Events,
      Started,
      Finished,
      Duration,
      [Duration (milliseconds)]

      FROM
      [Durations.xls]


      [New Table]:

      LOAD
      Year(Started) as YearStarted,
      [Case ID] as CaseID

      Resident[StatusLog];