Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(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
(ooxml, embedded labels, header is 2 lines, table is [Data base$])
There are at least the semi-colons missing - after the load-statements:
...
num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €] |
From
(ooxml, embedded labels, header is 2 lines, table is [Data base$]);
SLA_RAG_September:
Join(ISL_RAG)
...
- Marcus
Also ; is missing at the end of the statement.
Thanks a lot , the problem is solved .
Thank you very much , it's working for me.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .