Field names must be unique within table

[#1]

Hey everyone ,

for some reason i keep getting this error while debugging:

Field names must be unique within table: INV_SALES_TEMP: LOAD Date(IVDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE, IVNUM AS INV_INVNUM, DOC AS INV_DOC, IV, QPRICE AS INV_QPRICE, TOTPRICE AS INV_TOTPRICE , CURRENCY AS INV_CURRENCY, CUST AS CUST_CUST, DEBIT, FINAL AS INV_FINAL, ORD AS INV_ORD, DISCOUNT AS INV_DISCOUNT, PAYDATE AS INV_PAYDATE, FNCTRANS AS INV_FNCTRANS, BOOKNUM AS INV_BOOKNUM, AGENT AS INV_AGENT, BOOKNUM AS INV_BOOKNUM, "TYPE" AS INV_TYPE, CHECKING AS INV_CHECKING, IMPFILE AS INV_IMPFILE, STORNOFLAG AS INV_STORNOFLAG , BRANCH AS INV_BRANCH FROM [lib://Clinton key/Invoices.qvd] (qvd) where FINAL = 'Y' and Date (IVDATE/60/24+32143,'DD/MM/YYYY') >= '01/01/2010' and (TYPE='A' OR TYPE='C' OR TYPE='F' OR TYPE='E')

[jonathandienst · Accepted solution]

Because you are trying load BOOKNUM twice:

...NS, BOOKNUM AS INV_BOOKNUM, AGENT AS INV_AGENT, BOOKNUM AS INV_BOOKNUM, "TYPE ....

[maxgro]

maybe thi 2 x

Field names must be unique within table: INV_SALES_TEMP: LOAD Date(IVDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE, IVNUM AS INV_INVNUM, DOC AS INV_DOC, IV, QPRICE AS INV_QPRICE, TOTPRICE AS INV_TOTPRICE , CURRENCY AS INV_CURRENCY, CUST AS CUST_CUST, DEBIT, FINAL AS INV_FINAL, ORD AS INV_ORD, DISCOUNT AS INV_DISCOUNT, PAYDATE AS INV_PAYDATE, FNCTRANS AS INV_FNCTRANS, BOOKNUM AS INV_BOOKNUM, AGENT AS INV_AGENT, BOOKNUM AS INV_BOOKNUM, "TYPE" AS INV_TYPE, CHECKING AS INV_CHECKING, IMPFILE AS INV_IMPFILE, STORNOFLAG AS INV_STORNOFLAG , BRANCH AS INV_BRANCH FROM [lib://Clinton key/Invoices.qvd] (qvd) where FINAL = 'Y' and Date (IVDATE/60/24+32143,'DD/MM/YYYY') >= '01/01/2010' and (TYPE='A' OR TYPE='C' OR TYPE='F' OR TYPE='E')

• 5 Views
• Tags: