Duplicate keys when loading Input Field

[#1]

Good night staff,

can some please tell me what is wrong with this script?

Whenever I run gives the following error: "Duplicate keys When loading Input Field"

grateful

SCRIPT:

INPUTFIELD QTD;

FATOS:

LOAD

     CODIGOPARCEIRO AS ID_CLIENTE,

     CODIGOFUNCIONARIO AS ID_FUNCIONARIO,

     CODIGOMATERIAL AS ID_PRODUTO,

     CODIGOMATERIAL AS ID_MONTADORA,

     CODIGOMATERIAL AS ID_FABRICANTE,

     MOVIMENTO_ITEM.QUANTIDADE,

     MOVIMENTO_ITEM.QUANTIDADE as QTD,

     QTD_PROD

FROM [..\Extracao\TBE_FATOS_AUX.QVD] (qvd);

[ashfaq_haseeb]

Hi,

Try like this

SCRIPT:

INPUTFIELD QTD;

FATOS:

LOAD

     CODIGOPARCEIRO AS ID_CLIENTE,

     CODIGOFUNCIONARIO AS ID_FUNCIONARIO,

     CODIGOMATERIAL AS ID_PRODUTO,

     CODIGOMATERIAL AS ID_MONTADORA,

     CODIGOMATERIAL AS ID_FABRICANTE,

     MOVIMENTO_ITEM.QUANTIDADE,

     MOVIMENTO_ITEM.QUANTIDADE as QTDY,

     QTD_PROD

FROM [..\Extracao\TBE_FATOS_AUX.QVD] (qvd);

Regards

ASHFAQ

[#3]

Not really the error did not happen but the inputsum (QTD) neither.

[Anonymous]

Hi,

Try on field MOVIMENTO_ITEM.QUANTIDADE and check if it works.

Regards

Nitha

[#5]

Hi,

attachment follows the QVD and qvw

see if you can.

Thank you very much.

[#6]

Added files.

Can you do?

[#7]

I'm in version 11.2 SR7.

Inputfield works in this version?

I'm beginning to think not.

[#8 · Accepted solution]

Hello people,

I just found out the reason for the error.

I had to create a RECNO() field to serve as distinct in the table.

Thank you all.

[#9]

thank you soooooo much. I got struck with this for so long..

[andreas_koehler]

Thank you ! I also got stuck.