Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting Error while creating Mapping Table

Hi All, Iam new to Qlikview, Iam trying to create a Mapping table as shown below:
Directory
;
MapEmployee:
MAPPING LOAD EmpID,
[Last Name],
[First Name],
Title,
[Hire Date],
Office,
Extension,
[Reports To],
[Year Salary]
FROM
[..\Data\EmpOff.xls]
(
biff, embedded labels, table is Employee$);
The error is maaping requires 2-column input. Any help greatly appreciated
Thanks
1 Solution

Accepted Solutions
Michiel_QV_Fan
Specialist
Specialist

your table Directory; should only have 2 columns:

for instance:

mapping

load EmpID,

     Title

from ...

to map Title to your data.

View solution in original post

2 Replies
Michiel_QV_Fan
Specialist
Specialist

your table Directory; should only have 2 columns:

for instance:

mapping

load EmpID,

     Title

from ...

to map Title to your data.

Not applicable
Author

Thanks Michiel that helped