Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

Hi

You got two AS in the following line

[INTERNAL] AS AS INVOICES_INTERNAL,

and missing ";" at the end.

Hope it helps

Sasi

View solution in original post

6 Replies
oknotsen
Master III
Master III

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

May you live in interesting times!
Not applicable
Author

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

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

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

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

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

sasiparupudi1
Master III
Master III

Hi

You got two AS in the following line

[INTERNAL] AS AS INVOICES_INTERNAL,

and missing ";" at the end.

Hope it helps

Sasi