Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mamta123
Contributor II
Contributor II

Map_id not Found while using ApplyMap

I have 2 table,

Data Table: 

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

 

Team Mapping Data:

member name Team Name
ATeam A
BTeam B
CTeam 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

Labels (1)
8 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

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

Thanks and Regards
Kashyap.R
Mamta123
Contributor II
Contributor II
Author

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
Partner - Specialist
Partner - Specialist

Hi 

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

 

Thanks

 

Thanks and Regards
Kashyap.R
Mamta123
Contributor II
Contributor II
Author

Member Name and names are columns

 

Kashyap_R
Partner - Specialist
Partner - Specialist

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

Thanks and Regards
Kashyap.R
Mamta123
Contributor II
Contributor II
Author

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
Partner - Creator II
Partner - Creator II

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
Contributor II
Contributor II
Author

Thank you Prashant

It works fine now