topic Syntax Error in QlikView

Syntax Error

Fri, 11 Mar 2011 16:38:38 GMT

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 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

Syntax Error

tresB — Fri, 11 Mar 2011 16:49:12 GMT

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

Regards, tresesco

Syntax Error

Fri, 11 Mar 2011 16:58:27 GMT

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

Syntax Error

Fri, 11 Mar 2011 17:07:16 GMT

remove *FROM...

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

regards

Syntax Error

Fri, 11 Mar 2011 17:12:38 GMT

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

Syntax Error

tresB — Fri, 11 Mar 2011 17:15:34 GMT

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

Syntax Error

Fri, 11 Mar 2011 17:37:27 GMT

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

Syntax Error

tresB — Fri, 11 Mar 2011 17:42:42 GMT

have not you removed the comma i mentioned?

Syntax Error

Fri, 11 Mar 2011 17:55:56 GMT

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

Syntax Error

tresB — Fri, 11 Mar 2011 18:00:28 GMT

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

Syntax Error

Fri, 11 Mar 2011 18:21:24 GMT

I just attached the file and commented out the large ITEMLOC table because it was too large to post.

My tables are not working together. I need the tables to be joined by the ITEMNUMLOC.

Syntax Error

tresB — Fri, 11 Mar 2011 18:55:23 GMT

The code should be like this:


ODBC CONNECT32 TO Craftsman (XUserId is eMbVZQJMBLdaWQZNaH, XPassword is LIJYDUBGOCMEHaD);
Load *
From q:\abauman\qlikview_qvd\youarehereab.qvd
(qvd);

ITEMLOC:
LOAD
 VersionNum,
 ItemNum &'-'& ItemNum as ItemNumLoc,
 Description as DescriptionLoc,
 LocationNum,
 PiecesOnHand,
 TotalCost as TotalCostLoc;

SQL SELECT *

FROM TTM.ITEMLOC;

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

Copy it and paste in your second tab of script. it should work.

Syntax Error

Fri, 11 Mar 2011 22:47:23 GMT

Thanks for the help.

I need to put an if Statement in the script.

can you correct the way I have it now?

if OH >0 then PiecesOnHand else 0

How do I make that work in my script?

Thanks for all your help today.

Adam

Syntax Error

tresB — Sat, 12 Mar 2011 07:15:21 GMT

it should be like ( assuming that OH is a field name):

LOAD field1, field2,....

If( OH>0, PiecesOnHand , 0) as YourConditionalOH

FROM .....;

and yes, you haven't mentioned if the code (i suggested) worked. i am just curious.

Syntax Error

Mon, 14 Mar 2011 15:01:11 GMT

My tables from this file are not working together like i need them too. Should I do a left or an outer join?

I need my xls file to be the main table and then I need the actual "live" table to be updating fields only by the ItemNum's in my xls spreadsheet.

Where do I put the left or outer Join?

Syntax Error

tresB — Mon, 14 Mar 2011 17:18:52 GMT

i am not too sure what is you are looking for. guessing you need a LEFT JOIN (you should load excel file and put LEFT JOIN and load from your live data). in that case what would happen is:

all the records from excel would exist and the matching ItemNumLoc (key) records would be joined with the table (mentioned fields would be added for matched ItemNumLoc).

if you want this, go ahead with left join as mentioned.

Hope this helps.