5 Replies Latest reply: May 31, 2013 2:52 PM by Brian Garside RSS

    Syntax error, missing/misplaced FROM

    Brian Garside

      Below is my script, but I keep getting this error. I'm sure its something simple. Maybe Im missing a , ; or keyword.

       

      I'm trying to Sort my Project field and have to join with the Master table below. Is there a more efficient way to aplha order this field?

       

       

      Syntax error, missing/misplaced FROM:

      temp1:

      Load Project Order by Project

      temp1:

      Load Project Order by Project

       

       

      temp1:
      Load Project Order by Project//Sorted project field for Master Join
      SQL SELECT Project
      FROM CorpReporting.MonthlyBacklogForecastMaster;

      Join //Join Project field

      ForecastMaster:
      LOAD Autonumber(DataSetKey&'_'&Project) as %Key,     // Composite Join Key to ForecastRev
           DataSetKey,         

           Project,
          BacklogType,
      Description,
      EndUserCat,
      FundedAmt,
      Gate,
      ItdRevenue,
      MonthsLeftInPoP,
      PWin,
      TotalBacklogAmt;
      SQL SELECT
      DataSetKey,    

          Project,
      Description,
      BacklogType,
      ContractedAmt,
      EndUserCat,
      PWin,
      Gate,
      ItdRevenue,
      MonthsLeftInPoP,
      TotalBacklogAmt
      FROM CorpReporting.MonthlyBacklogForecastMaster;