Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

what this error is about

Hello ,

i am am trying to apply transformation but unfortunatelly i am getting error can any explain what this error is about ? do the way i doing transformation is correct ..?

Untitled.png

temp:

Mapping  LOAD OBJECTID as PRUEFLOS,

    VALUE_OLD

FROM

(qvd);

qave:

LOAD

ApplyMap('temp',PRUEFLOS,NULL()) AS VALUE_OLD,

PRUEFLOS,

    VCODE

FROM

(qvd);

LOAD VALUE_OLD,PRUEFLOS,VCODE,

VALUE_OLD&VCODE AS VCODE                                     //i think i am getting error over here

Resident qave;

drop Fields VALUE_OLD,VCODE;

Decision:

LOAD VCODE,

    Decision

  

FROM

(ooxml, embedded labels, table is Sheet1);

9 Replies
Highlighted
Champion
Champion

Re: what this error is about

you have some duplicate field names in script.

Vikas

Highlighted

Re: what this error is about

Name fields must be unique so you have declared twice "VCODE" field

Highlighted
Specialist
Specialist

Re: what this error is about

will it be ok if i do this



LOAD VALUE_OLD,PRUEFLOS,VCODE,

VALUE_OLD&VCODE AS vcode                                

Resident qave;

drop Fields VALUE_OLD,VCODE;

Highlighted
Champion
Champion

Re: what this error is about

yes

Highlighted
Champion
Champion

Re: what this error is about

it should not duplicate across the script


Vikas

Highlighted

Re: what this error is about

Yes

Highlighted
Specialist III
Specialist III

Re: what this error is about

Field names can be the same but must have capital letter (fields are different VCODE and vcode).

Lets say in your example the script will load even without drop fields statement.

Highlighted
Champion III
Champion III

Re: what this error is about

it will not allow duplicate.

but

Qlikview: is case sensitive

Qlikview Functions: Not case sensitive

Highlighted
Specialist
Specialist

Re: what this error is about

Hi, navee kumar.

The your problem is in Mapping. Alter name of field VALUE_OLD that will solve.

temp:

Mapping  LOAD OBJECTID as PRUEFLOS,

   VALUE_OLD  AS MAP_VALUE_OLD //Rename only for acept in ApplyMap();

FROM

(qvd);

qave:

LOAD

ApplyMap('temp',PRUEFLOS,NULL()) AS VALUE_OLD,

PRUEFLOS,

    VCODE

FROM

(qvd);

Regards,

Jonas Melo