topic Re: Syntax error, missing/misplaced FROM in QlikView

Syntax error, missing/misplaced FROM

Mon, 02 Nov 2015 10:09:55 GMT

i got this error but i cant realiy understand why....

The following error occurred:

Syntax error, missing/misplaced FROM:

[Invoices]:

LOAD

[IVDATE] AS INVOICES_IVDATE,

[IVNUM],

[DOC],

[IV] AS INVOICES_IV,

[QPRICE] AS INVOICES_QPRICE,

[TOTPRICE] AS INVOICES_TOTPRICE,

[CURRENCY] AS INVOICES_CURRENCY,

[CUST] AS INVOICES_CUST,

[DEBIT],

[IVREF],

[VAT],

[UDATE] AS INVOICES_UDATE,

[T$USER] AS INVOICES_T$USER,

[PRINTED],

[FINAL],

[ORD],

[DISCOUNT],

[DISPRICE],

[MONTHLY] AS INVOICES_MONTHLY,

[PAY] AS INVOICES_PAY ,

[FNCPATTERN] AS INVOICES_FNCPATTERN,

[PAYDATE],

[FNCTRANS],

[BOOKNUM]AS INVOICES_BOOKNUM ,

[AGENT] AS INVOICES_AGENTS,

[PIV],

[CALQPRICE] AS INVOICES_CALQPRICE,

[TYPE] AS INVOICES_TYPE,

[CHECKING],

[IMPFILE],

[IMPFIVTYPE],

[CASH] AS INVOICES_CASH,

[TOCASH],

[NOVATPRICE],

[VATPRICE],

[WARHS],

[TOWARHS],

[LCURRENCY],

[LEXCHANGE],

[WTAX],

[AFTERWTAX],

[WTAXPERCENT],

[IVBALANCE],

[ADVFLAG],

[ACCOUNT] AS INVOICES_ACCOUNT,

[CASHPAYMENT],

[STORNOFLAG] AS INVOICES_STORNOFLAG,

[TAX] AS INVOICES_TAX,

[INTERNAL] AS AS INVOICES_INTERNAL,

[BRANCH]AS INVOICES_BRANCH ,

[LIV],

[ADJPRICEFLAG],

[FNCITEMSFLAG],

[DETAILS],

[OWNER] AS INVOICES_OWNER,

[PHONE] AS INVOICES_PHONE,

[DESTCODE],

[SHIPTYPE] AS INVOICES_SHIPTYPE,

[BALDATE],

[PLIST],

[T$PERCENT] AS INVOICES_T$PERCENT,

[PACK],

[MWEIGHT],

[WEIGHT],

[AIRWAYBILL]

FROM [lib://clinton/Invoices.qvd] (qvd)

The error occurred here:

[Invoices]:

LOAD

[IVDATE] AS INVOICES_IVDATE,

[IVNUM],

[DOC],

[IV] AS INVOICES_IV,

[QPRICE] AS INVOICES_QPRICE,

[TOTPRICE] AS INVOICES_TOTPRICE,

[CURRENCY] AS INVOICES_CURRENCY,

[CUST] AS INVOICES_CUST,

[DEBIT],

[IVREF],

[VAT],

[UDATE] AS INVOICES_UDATE,

[T$USER] AS INVOICES_T$USER,

[PRINTED],

[FINAL],

[ORD],

[DISCOUNT],

[DISPRICE],

[MONTHLY] AS INVOICES_MONTHLY,

[PAY] AS INVOICES_PAY ,

[FNCPATTERN] AS INVOICES_FNCPATTERN,

[PAYDATE],

[FNCTRANS],

[BOOKNUM]AS INVOICES_BOOKNUM ,

[AGENT] AS INVOICES_AGENTS,

[PIV],

[CALQPRICE] AS INVOICES_CALQPRICE,

[TYPE] AS INVOICES_TYPE,

[CHECKING],

[IMPFILE],

[IMPFIVTYPE],

[CASH] AS INVOICES_CASH,

[TOCASH],

[NOVATPRICE],

[VATPRICE],

[WARHS],

[TOWARHS],

[LCURRENCY],

[LEXCHANGE],

[WTAX],

[AFTERWTAX],

[WTAXPERCENT],

[IVBALANCE],

[ADVFLAG],

[ACCOUNT] AS INVOICES_ACCOUNT,

[CASHPAYMENT],

[STORNOFLAG] AS INVOICES_STORNOFLAG,

[TAX] AS INVOICES_TAX,

[INTERNAL] AS AS INVOICES_INTERNAL,

[BRANCH]AS INVOICES_BRANCH ,

[LIV],

[ADJPRICEFLAG],

[FNCITEMSFLAG],

[DETAILS],

[OWNER] AS INVOICES_OWNER,

[PHONE] AS INVOICES_PHONE,

[DESTCODE],

[SHIPTYPE] AS INVOICES_SHIPTYPE,

[BALDATE],

[PLIST],

[T$PERCENT] AS INVOICES_T$PERCENT,

[PACK],

[MWEIGHT],

[WEIGHT],

[AIRWAYBILL]

FROM [lib://clinton/Invoices.qvd] (qvd)

Data has not been loaded. Please correct the error and try loading again.

Re: Syntax error, missing/misplaced FROM

oknotsen — Mon, 02 Nov 2015 10:16:02 GMT

You are missing a semi-colon at the end of your script.

Re: Syntax error, missing/misplaced FROM

Mon, 02 Nov 2015 12:58:37 GMT

hey i corrected it but still got an error

The following error occurred:

Syntax error, missing/misplaced FROM:

[Invoices]:

LOAD

[IVDATE] AS INVOICES_IVDATE,

[IVNUM],

[DOC],

[IV] AS INVOICES_IV,

[QPRICE] AS INVOICES_QPRICE,

[TOTPRICE] AS INVOICES_TOTPRICE,

[CURRENCY] AS INVOICES_CURRENCY,

[CUST] AS INVOICES_CUST,

[DEBIT],

[IVREF],

[VAT],

[UDATE] AS INVOICES_UDATE,

[T$USER] AS INVOICES_T$USER,

[PRINTED],

[FINAL],

[ORD],

[DISCOUNT],

[DISPRICE],

[MONTHLY] AS INVOICES_MONTHLY,

[PAY] AS INVOICES_PAY ,

[FNCPATTERN] AS INVOICES_FNCPATTERN,

[PAYDATE],

[FNCTRANS],

[BOOKNUM]AS INVOICES_BOOKNUM ,

[AGENT] AS INVOICES_AGENTS,

[PIV],

[CALQPRICE] AS INVOICES_CALQPRICE,

[TYPE] AS INVOICES_TYPE,

[CHECKING],

[IMPFILE],

[IMPFIVTYPE],

[CASH] AS INVOICES_CASH,

[TOCASH],

[NOVATPRICE],

[VATPRICE],

[WARHS],

[TOWARHS],

[LCURRENCY],

[LEXCHANGE],

[WTAX],

[AFTERWTAX],

[WTAXPERCENT],

[IVBALANCE],

[ADVFLAG],

[ACCOUNT] AS INVOICES_ACCOUNT,

[CASHPAYMENT],

[STORNOFLAG] AS INVOICES_STORNOFLAG,

[TAX] AS INVOICES_TAX,

[INTERNAL] AS AS INVOICES_INTERNAL,

[BRANCH]AS INVOICES_BRANCH ,

[LIV],

[ADJPRICEFLAG],

[FNCITEMSFLAG],

[DETAILS],

[OWNER] AS INVOICES_OWNER,

[PHONE] AS INVOICES_PHONE,

[DESTCODE],

[SHIPTYPE] AS INVOICES_SHIPTYPE,

[BALDATE],

[PLIST],

[T$PERCENT] AS INVOICES_T$PERCENT,

[PACK],

[MWEIGHT],

[WEIGHT],

[AIRWAYBILL]

FROM [lib://clinton/Invoices.qvd] (qvd)

The error occurred here:

[Invoices]:

LOAD

[IVDATE] AS INVOICES_IVDATE,

[IVNUM],

[DOC],

[IV] AS INVOICES_IV,

[QPRICE] AS INVOICES_QPRICE,

[TOTPRICE] AS INVOICES_TOTPRICE,

[CURRENCY] AS INVOICES_CURRENCY,

[CUST] AS INVOICES_CUST,

[DEBIT],

[IVREF],

[VAT],

[UDATE] AS INVOICES_UDATE,

[T$USER] AS INVOICES_T$USER,

[PRINTED],

[FINAL],

[ORD],

[DISCOUNT],

[DISPRICE],

[MONTHLY] AS INVOICES_MONTHLY,

[PAY] AS INVOICES_PAY ,

[FNCPATTERN] AS INVOICES_FNCPATTERN,

[PAYDATE],

[FNCTRANS],

[BOOKNUM]AS INVOICES_BOOKNUM ,

[AGENT] AS INVOICES_AGENTS,

[PIV],

[CALQPRICE] AS INVOICES_CALQPRICE,

[TYPE] AS INVOICES_TYPE,

[CHECKING],

[IMPFILE],

[IMPFIVTYPE],

[CASH] AS INVOICES_CASH,

[TOCASH],

[NOVATPRICE],

[VATPRICE],

[WARHS],

[TOWARHS],

[LCURRENCY],

[LEXCHANGE],

[WTAX],

[AFTERWTAX],

[WTAXPERCENT],

[IVBALANCE],

[ADVFLAG],

[ACCOUNT] AS INVOICES_ACCOUNT,

[CASHPAYMENT],

[STORNOFLAG] AS INVOICES_STORNOFLAG,

[TAX] AS INVOICES_TAX,

[INTERNAL] AS AS INVOICES_INTERNAL,

[BRANCH]AS INVOICES_BRANCH ,

[LIV],

[ADJPRICEFLAG],

[FNCITEMSFLAG],

[DETAILS],

[OWNER] AS INVOICES_OWNER,

[PHONE] AS INVOICES_PHONE,

[DESTCODE],

[SHIPTYPE] AS INVOICES_SHIPTYPE,

[BALDATE],

[PLIST],

[T$PERCENT] AS INVOICES_T$PERCENT,

[PACK],

[MWEIGHT],

[WEIGHT],

[AIRWAYBILL]

FROM [lib://clinton/Invoices.qvd] (qvd);

Data has not been loaded. Please correct the error and try loading again.

Re: Syntax error, missing/misplaced FROM

sasikanth — Mon, 02 Nov 2015 13:19:09 GMT

hi,

[INTERNAL] AS AS INVOICES_INTERNAL,

Here you wrote 2 AS keywords remove one and end of the script give one semi colon

use the following script

[Invoices]:

LOAD

[IVDATE] AS INVOICES_IVDATE,

[IVNUM],

[DOC],

[IV] AS INVOICES_IV,

[QPRICE] AS INVOICES_QPRICE,

[TOTPRICE] AS INVOICES_TOTPRICE,

[CURRENCY] AS INVOICES_CURRENCY,

[CUST] AS INVOICES_CUST,

[DEBIT],

[IVREF],

[VAT],

[UDATE] AS INVOICES_UDATE,

[T$USER] AS INVOICES_T$USER,

[PRINTED],

[FINAL],

[ORD],

[DISCOUNT],

[DISPRICE],

[MONTHLY] AS INVOICES_MONTHLY,

[PAY] AS INVOICES_PAY ,

[FNCPATTERN] AS INVOICES_FNCPATTERN,

[PAYDATE],

[FNCTRANS],

[BOOKNUM]AS INVOICES_BOOKNUM ,

[AGENT] AS INVOICES_AGENTS,

[PIV],

[CALQPRICE] AS INVOICES_CALQPRICE,

[TYPE] AS INVOICES_TYPE,

[CHECKING],

[IMPFILE],

[IMPFIVTYPE],

[CASH] AS INVOICES_CASH,

[TOCASH],

[NOVATPRICE],

[VATPRICE],

[WARHS],

[TOWARHS],

[LCURRENCY],

[LEXCHANGE],

[WTAX],

[AFTERWTAX],

[WTAXPERCENT],

[IVBALANCE],

[ADVFLAG],

[ACCOUNT] AS INVOICES_ACCOUNT,

[CASHPAYMENT],

[STORNOFLAG] AS INVOICES_STORNOFLAG,

[TAX] AS INVOICES_TAX,

[INTERNAL] AS INVOICES_INTERNAL,

[BRANCH] AS INVOICES_BRANCH ,

[LIV],

[ADJPRICEFLAG],

[FNCITEMSFLAG],

[DETAILS],

[OWNER] AS INVOICES_OWNER,

[PHONE] AS INVOICES_PHONE,

[DESTCODE],

[SHIPTYPE] AS INVOICES_SHIPTYPE,

[BALDATE],

[PLIST],

[T$PERCENT] AS INVOICES_T$PERCENT,

[PACK],

[MWEIGHT],

[WEIGHT],

[AIRWAYBILL]

FROM [lib://clinton/Invoices.qvd] (qvd);

Re: Syntax error, missing/misplaced FROM

jafari_ervin — Mon, 02 Nov 2015 13:48:03 GMT

You should write semicolon after load script "(qvd);"

Re: Syntax error, missing/misplaced FROM

Gabriel — Mon, 02 Nov 2015 13:55:16 GMT

Hi,

You have 2 Invoices Load. The first part of the Invoice load is missing semicolon (;) after the (qvd). Please add semicolon and reload

Re: Syntax error, missing/misplaced FROM

sasiparupudi1 — Mon, 02 Nov 2015 14:20:50 GMT

You got two AS in the following line

[INTERNAL] AS AS INVOICES_INTERNAL,

and missing ";" at the end.

Hope it helps

Sasi