Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Im trying to create a new field within another field. I have a field called Sales forecast which Budget forecast belongs to as an element. I would like to save 'Budget Forecast' (which is in the field [Sales Forecast]) as an own field. When i try to do this in the qv import script i get two error messages: Syntax error, missing/misplaced and table not found. Can anyone please help me to spot what is wrong with the code?
Thank you
Regards
Glenn
Budget_import:
LOAD [Product Type],
[Sales Forecast],
Division,
Customer,
Time,
[Customer Revenues]
FROM
(ooxml, embedded labels, table is [Budget Sales Forecast]);
Budget_Field:
Load
[Product Type],
[Sales Forecast],
If([Sales Forecast]='Budget Forecast 2010',[Customer Reveneus])as budget
Divsion,
Customer,
Time,
[Customer Revenues]
Resident Budget_import;
Drop Table Budget_import;
you forgot a comma sign after the "buget"
Hi again,
Thanks for the quick reply. The comma problem is now fixed 🙂
However, I still get the "table not found problem"
Table not found
Budget_Field:
Load
[Product Type],
[Sales Forecast],
If([Sales Forecast]='Budget Forecast 2010',[Customer Reveneus])as budget,
Divsion,
Customer,
Time,
[Customer Revenues]
Resident Budget_import