Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lavrendis
New Contributor

"Duplicate Derived Field" error message

Hi there,

i am trying to load a second table in my app and i get the message of "Duplicate Derived Field" at the end of load.

Could someone explain to me how to interpret the message and what i should search for?

Thank you,

Lawrence

6 Replies
vinieme12
Esteemed Contributor II

Re: "Duplicate Derived Field" error message

can you post a screenshot? does it tell you what field?

and the entire table load also fails?

Not applicable

Re: "Duplicate Derived Field" error message

Hi,

I believe that me and Lawrence are having the same problem.

In my case the message showed by Qlik Sense is:

The following errors occurred:

Duplicate Derived Field

The error occurred here:

DERIVE FIELDS FROM FIELDS [AGN_DT_ULTIMAATUCAD], [DT_LANCAMENTO], [DT_INICIO_OBRA], [DT_PREV_TERMINO_OBRA], [DT_PREV_ULTIMA_ENTREGA], [ORG_DT_REGISTRO], [BLO_DT_ENTREGA], [EST_DT_LANCAMENTO], [EST_DT_INICIOOBRA], [EST_DT_FIMOBRA], [UND_DATA_SITUACAO], [DATA_FECHAMENTO], [DT_VALIDADE_PROPOSTA], [CND_DT_STATUS] USING [autoCalendar]

This error occur on the auto generated load script for 7 views using a Oracle Database Connection.

lavrendis
New Contributor

Re: "Duplicate Derived Field" error message

Hi there,

i noticed that i get this message when i have different Auto-generated sections in the data load editor.

The message is the following: Duplicate Derived Field: DERIVE FIELDS FROM FIELDS [REQDATEORDER] USING [autoCalendar]

This is the second line of "Derive fields from fields" in the script. But even if i copy all the fields in one line i get the same message but them with all the fields included.

In fact today i am blocked because it seems that i cannot add more than 1 tables in my app and then unblock the script.

Thank you for your help,

Lawrence

Not applicable

Re: "Duplicate Derived Field" error message

Hi,

What I'm thinking you have two [autoCalendar], right? how about define like this [autoCalendar1] and [autoCalendar2], and see what will happen then

Thank you,

Yuwei

sasiparupudi1
Honored Contributor III

Re: "Duplicate Derived Field" error message

please post  a sample app or share your script so that we can better understand the issue you are facing

nurmahirahaqila
New Contributor

Re: "Duplicate Derived Field" error message

This should be the answer

Community Browser