mapping problem

[#1]

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

[tresesco]

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

[#3]

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

[#4]

Field not found - <LOAD>

LOAD deptno,

     name

FROM

C:\qlikview\emp.xlsx

(ooxml, embedded labels, table is Sheet1)

2

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)

[#5]

Unknown statement

applying map('map_name',deptno) as name2

[#6]

its applymap , not applying map

[#7]

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

[jagannalla · Accepted solution]

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

[#9]

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

[#10]

same problem came