topic Field names must be unique within table in App Development

Field names must be unique within table

Tue, 01 Dec 2015 14:00:46 GMT

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

Re: Field names must be unique within table

jonathandienst — Tue, 01 Dec 2015 14:13:50 GMT

Because you are trying load BOOKNUM twice:

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

Re: Field names must be unique within table

maxgro — Tue, 01 Dec 2015 14:16:30 GMT

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: