Syntax Error

[#1]

Why am I getting an error on the script below?

//ODBC CONNECT32 TO Craftsman (XUserId is eMbVZQJMBLdaWQZNaH, XPassword is LIJYDUBGOCMEHaD);

Load

*

From q:\abauman\qlikview_qvd\youarehereab.qvd

(qvd);

ITEMLOC:

LOAD

VersionNum,

ItemNum,

ItemNum &'-'& ItemNum as ItemNumLoc,

LocationNum,

PiecesOnHand,

TotalCost as TotalCostLoc,

SQL SELECT *

FROM TTM.ITEMLOC;

Store

* FROM ITEMLOC into Q:\ABauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd;

Why am I gett an error on this below.

//ODBC CONNECT32 TO Craftsman (XUserId is eMbVZQJMBLdaWQZNaH, XPassword is LIJYDUBGOCMEHaD);

Load

qvd);ITEMLOC:

LOAD

VersionNum,

ItemNum

,

ItemNum

&'-'& ItemNum as ItemNumLoc,

LocationNum

,

Description as DescriptionLoc,

*From q:\abauman\qlikview_qvd\youarehereab.qvd

(

PiecesOnHand,

TotalCost

as TotalCostLoc,

SQL

SELECT *FROM TTM.ITEMLOC;

Store

Q:\ABauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd;

* FROM ITEMLOC into

[tresesco]

Remove ',' (comma) from your code -" TotalCost as TotalCostLoc,"

Regards, tresesco

[#3]

Thanks I am re-running that now.

I am also getting a Syntax error for the Script below:

Table not Found

Store *FROM ITEMLOC into Q:Abauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd

[#4]

remove *FROM...

Store ITEMLOC into Q:Abauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd

regards

[#5]

Ok i will try that but i am still getting an error on this script:

Syntax error, missing/misplaced FROM:
ITEMLOC:
LOAD VersionNum,
ItemNum,
ItemNum &'-'& ItemNum as ItemNumLoc,
LocationNum,
Description as DescriptionLoc,
PiecesOnHand,
TotalCost as TotalCostLoc

[tresesco]

"

SQL SELECT *

FROM TTM.ITEMLOC;

Store

* FROM ITEMLOC into Q:\ABauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd;

"

In the above code slice, put a labe(table name), and try to store that table like:

ITEMLOC:
SQL SELECT *

FROM TTM.ITEMLOC;

Store ITEMLOC into Q:\ABauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd;

Regards, tresesco

[#7]

I am still getting this error below??

Syntax error, missing/misplaced FROM:

ITEMLOC:

LOAD VersionNum,

ItemNum &'-'& ItemNum as ItemNumLoc,

LocationNum,

Description as DescriptionLoc,

PiecesOnHand,

TotalCost as TotalCostLoc,

I have another error as well when I reload:

Table not found

Store ITEMLOC into Q:\ABauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd

[tresesco]

have not you removed the comma i mentioned?

[#9]

I did a reload again without the comma, but still got an error. What am I missing?

Syntax error, missing/misplaced FROM:

ITEMLOC:

LOAD VersionNum,

ItemNum &'-'& ItemNum as ItemNumLoc,

LocationNum,

Description as DescriptionLoc,

PiecesOnHand,

TotalCost as TotalCostLoc

Also I still got an error for this Syntax:

Table not found

Store ITEMLOC into Q:\ABauman\QLIKVIEW_QVD\YOUAREHEREAB.qvd

[tresesco]

can you please upload the sample application? don't worry about the data source, i would test using different sample data.