2 Replies Latest reply: Dec 1, 2015 9:16 AM by Massimo Grossi RSS

    Field names must be unique within table

    jhonatan ben ami

      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
          Jonathan Dienst

          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
            Massimo Grossi

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