Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Syntax error, missing/misplaced FROM

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.

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Syntax error, missing/misplaced FROM

Hi

You got two AS in the following line

[INTERNAL] AS AS INVOICES_INTERNAL,

and missing ";" at the end.

Hope it helps

Sasi

6 Replies
oknotsen
Honored Contributor III

Re: Syntax error, missing/misplaced FROM

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

May you live in interesting times!
Not applicable

Re: Syntax error, missing/misplaced FROM

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.

sasikanth
Valued Contributor III

Re: Syntax error, missing/misplaced FROM

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

jafari_ervin
Contributor III

Re: Syntax error, missing/misplaced FROM

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

Gabriel
Valued Contributor III

Re: Syntax error, missing/misplaced FROM

Hi,

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

sasiparupudi1
Honored Contributor III

Re: Syntax error, missing/misplaced FROM

Hi

You got two AS in the following line

[INTERNAL] AS AS INVOICES_INTERNAL,

and missing ";" at the end.

Hope it helps

Sasi