look up maping

[nagasekhar]

WHY  I AM GETTING BLANK VALUES HERE?

SCRIPT:

Directory;
T2:
LOAD StudentID,
[m marks]
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is [M marks]);
T1:
LOAD StudentID,
[sc marks]
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is [sc marks]);

Directory;
Student:
LOAD StudentID,
name,
Lookup('[sc marks]','StudentID',StudentID,'T1') as scmarks,
Lookup('[m marks]','StudentID',StudentID,'T2') as mamarks
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is Sheet3);

[nagasekhar]

T1:
LOAD StudentID,
[sc marks]
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is [sc marks]);

T2:
LOAD StudentID,
[m marks]
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is [M marks]);

Student:
LOAD StudentID,
name,
Lookup('sc marks','StudentID',StudentID,'T1') as scmarks,
Lookup('m marks','StudentID',StudentID,'T2') as mamarks
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is Sheet3);

DROP Tables T1,T2;

[vinieme12]

use Applymap() instead

T1:
Mapping LOAD StudentID,
[sc marks]
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is [sc marks]);

T2:
Mapping LOAD StudentID,
[m marks]
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is [M marks]);

Student:
LOAD StudentID,
name,
Applymap('T1',StudentID) as scmarks,
Applymap('T2',StudentID) as mmarks
FROM
[C:\Users\User\Downloads\New folder (5)\qlik files\lookup.xlsx]
(ooxml, embedded labels, table is Sheet3);

//DROP Tables T1,T2; not needed as mapping tables are not stored