topic Syntax error, missing/misplaced (Trying to create a new field) in QlikView

Syntax error, missing/misplaced (Trying to create a new field)

Mon, 14 Jun 2010 18:25:36 GMT

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;

Syntax error, missing/misplaced (Trying to create a new field)

Mon, 14 Jun 2010 18:52:28 GMT

you forgot a comma sign after the "buget"

Syntax error, missing/misplaced (Trying to create a new field)

Mon, 14 Jun 2010 19:09:10 GMT

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