topic Re: Duplicate keys when loading Input Field in QlikView

Duplicate keys when loading Input Field

Sun, 05 Oct 2014 01:55:32 GMT

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

Re: Duplicate keys when loading Input Field

ashfaq_haseeb — Sun, 05 Oct 2014 14:08:13 GMT

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

Re: Duplicate keys when loading Input Field

Sun, 05 Oct 2014 18:55:47 GMT

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

Re: Duplicate keys when loading Input Field

Anonymous — Sun, 05 Oct 2014 19:30:19 GMT

Hi,

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

Regards

Nitha

Re: Re: Duplicate keys when loading Input Field

Sun, 05 Oct 2014 21:10:08 GMT

Hi,

attachment follows the QVD and qvw

see if you can.

Thank you very much.

Re: Duplicate keys when loading Input Field

Mon, 06 Oct 2014 18:34:22 GMT

Added files.

Can you do?

Re: Duplicate keys when loading Input Field

Mon, 06 Oct 2014 18:56:05 GMT

I'm in version 11.2 SR7.

Inputfield works in this version?

I'm beginning to think not.

Re: Duplicate keys when loading Input Field

Mon, 06 Oct 2014 19:21:26 GMT

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.

Re: Duplicate keys when loading Input Field

Tue, 18 Nov 2014 07:54:59 GMT

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

Re: Duplicate keys when loading Input Field

andreas_koehler — Tue, 12 Apr 2016 14:04:49 GMT

Thank you ! I also got stuck.