what this error is about

[kunkumnaveen]

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 ..?

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

[vikasmahajan]

you have some duplicate field names in script.

Vikas

[alexandros17]

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

[kunkumnaveen]

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;

[vikasmahajan]

yes

[vikasmahajan]

it should not duplicate across the script

Vikas

[alexandros17]

Yes

[MindaugasBacius]

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.

[Chanty4u]

it will not allow duplicate.

but

Qlikview: is case sensitive

Qlikview Functions: Not case sensitive

[jonas_rezende]

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