Syntax error, missing/misplaced (Trying to create a new field)
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?
LOAD [Product Type], [Sales Forecast], Division, Customer, Time, [Customer Revenues] FROM (ooxml, embedded labels, table is [Budget Sales Forecast]);