topic what this error is about in QlikView

what this error is about

kunkumnaveen — Wed, 20 Apr 2016 11:41:30 GMT

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

Re: what this error is about

vikasmahajan — Wed, 20 Apr 2016 11:43:36 GMT

you have some duplicate field names in script.

Vikas

Re: what this error is about

alexandros17 — Wed, 20 Apr 2016 11:44:00 GMT

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

Re: what this error is about

kunkumnaveen — Wed, 20 Apr 2016 11:47:00 GMT

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;

Re: what this error is about

vikasmahajan — Wed, 20 Apr 2016 11:48:09 GMT

yes

Re: what this error is about

vikasmahajan — Wed, 20 Apr 2016 11:48:41 GMT

it should not duplicate across the script

Vikas

Re: what this error is about

alexandros17 — Wed, 20 Apr 2016 11:54:41 GMT

Yes

Re: what this error is about

MindaugasBacius — Wed, 20 Apr 2016 12:01:49 GMT

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.

Re: what this error is about

Chanty4u — Wed, 20 Apr 2016 12:15:14 GMT

it will not allow duplicate.

but

Qlikview: is case sensitive

Qlikview Functions: Not case sensitive

Re: what this error is about

jonas_rezende — Wed, 20 Apr 2016 12:28:05 GMT

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