Map_id not Found while using ApplyMap

[Mamta123]

I have 2 table,

Data Table: 

Id	names
1	A
2	B
3	B
4	C
5	C
6	D
7	E

Team Mapping Data:

member name	Team Name
A	Team A
B	Team B
C	Team A

I want a team column against each Id. If there is no match it should show as Unassigned. I tried Applymap but getting an error:   map_id not found

[Data ]:
LOAD *,
ApplyMap('[Team Mapping]', [Team Name],'Unassigned') As Team
;

Can anyone help me on this one. Thanks in Advance

[Kashyap_R]

Hi

Can u share the Code what you have written

Have you used mapping keyword and also check that the mapping table should have only 2 columns

Thanks

[Mamta123]

I'm using this code::

[Team Mapping data]:
LOAD
[member name],
[team name]
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is [Team Mapping data]);

[Data]:
LOAD
[Id],
[Names]
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is Data);

[Data ]:
LOAD *,
ApplyMap('[Team Mapping]', [Team Name],'Unassigned') As Team
;

[Kashyap_R]

Hi 

Can you tell me which columns are Common between the 2 tables?

Thanks

[Mamta123]

Member Name and names are columns

[Kashyap_R]

Hi

Try this and let me know if it works

[Team Mapping data]:
Mapping
LOAD
[member name] as [Names],
[team name]
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is [Team Mapping data]);

[Data]:
LOAD
[Id],
[Names],

ApplyMap('[Team Mapping]', [Names],'Unassigned') As Team
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is Data);

Hope this Helps

Thanks

[Mamta123]

The following error occurred:

ApplyMap error:
map_id not found

I have used the code:

Unqualify *;

[Team Mapping]:
Mapping
LOAD
[member name] as [Names],
[team name]
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is [Team Mapping data]);

[Data]:
LOAD
[Id],
[Names],
ApplyMap('[Team Mapping]', [Names],'Unassigned') As Team
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is Data);

[Prashant_Naik]

Hi Mamta,

This might help you

[Team Mapping]:
Mapping
LOAD
[member name] as [Names],
[team name]
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is [Team Mapping data]);

[Data]:
LOAD
[Id],
[Names],
ApplyMap('Team Mapping', Names,'Unassigned') As Team
FROM [lib://Raw/test_qlik.xlsx]
(ooxml, embedded labels, table is Data);

Regards,

Prashant

[Mamta123]

Thank you Prashant

It works fine now