5 Replies Latest reply: Sep 8, 2017 3:34 AM by Onno van Knotsenburg RSS

    Syntax error, missing/misplaced FROM

    Chloe Li

      Hello all,

      i have a problem when I'm reloading the script , the scripte is as below. but it can be reload in my  colleqgue's computer, do you have any idea about it ?

       

      Syntax error, missing/misplaced FROM:

      SLA_RAG_September:

      Join(ISL_RAG)

      LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,

           [Code marché(R1)],

           [Family(R0)],

           [Family Code(R1)],

           [GMID Code(R1)] as [GMID Code],

           [Supply Chain Product Description(R0)],

           [Groupe Usine Code(R0)],

           [Groupe Usine(R0)],

           [Division Usine Majeure(R0)],

           [Statut du lien(R0)],

           [Statut du Produit(R0)],

           [Quantité Prévue(R5)],

           [Quantité Vendue],

           [Sales 3 Months / Forecasts 3 months],

           [Quantité engagement],

           [Stock Total CDIS],

           [Stock Sécu(JO)(R1)],

           [* SSV],

           [Stock Maxi(JO)(R1)],

           [Quantité Prévue(R2)],

           [* Stock Target MIN [Packs]]],

           [* Stock Target MAX [Packs]]],

           [* RAG Delay [Packs]]],

           [* Stock Mkt  ONLY],

           [Stock Total MKT],

           [Stock Transit MKT],

           [* MKT Coverage [in months]]],

           [* % of Stock Mkt missing to reach MIN Stk Target],

           [* RAG Delay [Packs]]1],

           [* SKU below MIN Target],

           [* SKU within the limits],

           [* SKU above MAX Target],

           [* RAG Excess [Packs]]],

           [* % of Stock Mkt above MAX Stock Target],

           [* % of Stock Within the TARGETS],

           [% RAG/(RAG+BAD) 3 mois(R0)],

        

      ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],

           ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],

           ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],

           Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],

           Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],

           num(if(Isnull([* Stock Mkt  ONLY]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[* Stock Mkt  ONLY])),'0,00') as [stock market only valued in €],

           num(if(IsNull([Quantité Prévue(R2)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R2)])),'0,0') as [3 next month forecast sales in €],

           num(if(isnull([Quantité Prévue(R5)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R5)])),'0,0') as [Forecast last 3 months in €],

           num(if(isnull([Quantité Vendue]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Vendue])),'0,0') as [Sales last 3 months in €],

           num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],

           num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]

      From

      [C:\Users\I0337431\Desktop\SLA Compliance.xls]

      (ooxml, embedded labels, header is 2 lines, table is [Data base$])

      SLA_RAG_September:

      Join(ISL_RAG)

      LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,

           [Code marché(R1)],

           [Family(R0)],

           [Family Code(R1)],

           [GMID Code(R1)] as [GMID Code],

           [Supply Chain Product Description(R0)],

           [Groupe Usine Code(R0)],

           [Groupe Usine(R0)],

           [Division Usine Majeure(R0)],

           [Statut du lien(R0)],

           [Statut du Produit(R0)],

           [Quantité Prévue(R5)],

           [Quantité Vendue],

           [Sales 3 Months / Forecasts 3 months],

           [Quantité engagement],

           [Stock Total CDIS],

           [Stock Sécu(JO)(R1)],

           [* SSV],

           [Stock Maxi(JO)(R1)],

           [Quantité Prévue(R2)],

           [* Stock Target MIN [Packs]]],

           [* Stock Target MAX [Packs]]],

           [* RAG Delay [Packs]]],

           [* Stock Mkt  ONLY],

           [Stock Total MKT],

           [Stock Transit MKT],

           [* MKT Coverage [in months]]],

           [* % of Stock Mkt missing to reach MIN Stk Target],

           [* RAG Delay [Packs]]1],

           [* SKU below MIN Target],

           [* SKU within the limits],

           [* SKU above MAX Target],

           [* RAG Excess [Packs]]],

           [* % of Stock Mkt above MAX Stock Target],

           [* % of Stock Within the TARGETS],

           [% RAG/(RAG+BAD) 3 mois(R0)],

        

      ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],

           ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],

           ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],

           Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],

           Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],

           num(if(Isnull([* Stock Mkt  ONLY]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[* Stock Mkt  ONLY])),'0,00') as [stock market only valued in €],

           num(if(IsNull([Quantité Prévue(R2)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R2)])),'0,0') as [3 next month forecast sales in €],

           num(if(isnull([Quantité Prévue(R5)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R5)])),'0,0') as [Forecast last 3 months in €],

           num(if(isnull([Quantité Vendue]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Vendue])),'0,0') as [Sales last 3 months in €],

           num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],

           num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]

      From

      [C:\Users\I0337431\Desktop\SLA Compliance.xls]

      (ooxml, embedded labels, header is 2 lines, table is [Data base$])