topic Re: mapping problem in QlikView

mapping problem

Fri, 04 Oct 2013 09:47:52 GMT

map_name:

Mapping LOAD;

LOAD deptno,

name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1);

emp:

LOAD deptno,

location

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2);

applying map('map_name',deptno) as name2

ERRORS

1) field not found

2)unkonown statment

Re: mapping problem

tresB — Fri, 04 Oct 2013 10:08:05 GMT

Guess, it should be something like:

map_name:

Mapping LOAD;

LOAD deptno,

name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1);

emp:

LOAD deptno,

applying map('map_name',deptno) as name2,

location

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2);

Re: mapping problem

Fri, 04 Oct 2013 10:10:42 GMT

Hi Vinay,

Try this.

map_name:

Mapping LOAD deptno,

name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1);

emp:

LOAD deptno,

location

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2);

applying map('map_name',deptno) as name2

Regards,

Anju

Re: mapping problem

Fri, 04 Oct 2013 10:27:49 GMT

Field not found - <LOAD>

LOAD deptno,

name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1)

Syntax error, missing/misplaced FROM:

emp:

LOAD deptno,

applying map('map_name',deptno) as name2,

location

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2)

emp:

LOAD deptno,

applying map('map_name',deptno) as name2,

location

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2)

Re: mapping problem

Fri, 04 Oct 2013 10:29:20 GMT

Unknown statement

applying map('map_name',deptno) as name2

Re: mapping problem

Fri, 04 Oct 2013 10:31:08 GMT

its applymap , not applying map

Re: mapping problem

Fri, 04 Oct 2013 10:33:17 GMT

May be it can be work....

map_name:

Mapping LOAD deptno,

name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1);

emp:

LOAD deptno,

applymap('map_name',deptno) as name2,

location

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2);

Re: Re: mapping problem

jagannalla — Fri, 04 Oct 2013 10:36:10 GMT

Hi Vinay,

Please try to load data from excel first, If it works then try to implement the concept of mapping.

Map1:

Mapping

LOAD deptno,

name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1);

Emp:

LOAD deptno,

location,

applymap('Map1',deptno) as name2

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2);

Hope it helps you.

Cheers!!

Jagan

Re: mapping problem

Fri, 04 Oct 2013 10:38:16 GMT

tresesco wrote:

Guess, it should be something like:

map_name:

Mapping LOAD;

LOAD deptno,

     name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1);

emp:

LOAD deptno,

       applying map('map_name',deptno) as name2,

     location

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2);

just modifying tresesco's script :

map_name:

Mapping

LOAD DEPTNO,

NAME

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1);

emp:

LOAD DEPTNO,

APPLYMAP ('map_name',DEPTNO) as name2,

LOCATION

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet2);

Just be careful to put the field you are mapping in capital letters.

I faced this issue earlier... it does not work with small letters.

Regards,

Anju

Re: mapping problem

Fri, 04 Oct 2013 10:38:35 GMT

same problem came

Re: mapping problem

Fri, 04 Oct 2013 10:45:58 GMT

same problem came