topic Getting Error while creating Mapping Table in QlikView

Getting Error while creating Mapping Table

Tue, 24 Apr 2012 06:34:48 GMT

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

Getting Error while creating Mapping Table

Michiel_QV_Fan — Tue, 24 Apr 2012 06:41:02 GMT

your table Directory; should only have 2 columns:

for instance:

mapping

load EmpID,

Title

from ...

to map Title to your data.

Getting Error while creating Mapping Table

Tue, 24 Apr 2012 06:54:48 GMT

Thanks Michiel that helped