Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Field names must be unique within table

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Field names must be unique within table

Because you are trying load BOOKNUM twice:

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

2 Replies
MVP
MVP

Re: Field names must be unique within table

Because you are trying load BOOKNUM twice:

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

MVP
MVP

Re: Field names must be unique within table

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