Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicate keys when loading Input Field

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

9 Replies
ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

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

Sem título.jpg

Anonymous
Not applicable
Author

Hi,

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

Regards

Nitha

Not applicable
Author

Hi,

attachment follows the QVD and qvw

see if you can.

Thank you very much.

Not applicable
Author

Added files.

Can you do?

Not applicable
Author

I'm in version 11.2 SR7.

Inputfield works in this version?

I'm beginning to think not.

Not applicable
Author

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.

Not applicable
Author

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

andreas_koehler
Creator II
Creator II

Thank you ! I also got stuck.