topic Re: MAPPING requires 2-column input!!!! in QlikView

MAPPING requires 2-column input!!!!

Tue, 19 Aug 2014 16:38:31 GMT

Hi All ,

Am Creating ht ApplyMap between 2 Tables when i reload the table am getting error like MAPPING requires 2-column input! can give me the solution whats wrong in that ?

plaese find below script;

Thanks in advance

GIS_DEPARTMENT_MSTR:

Mapping

LOAD

DEPARTMENT_CODE ,

DEPARTMENT_NAME,

D_LOB,

CLIENT_NAME as CLIENT_NAME,

INT_VERTICAL_CODE as INT_VERTICAL_CODE

FROM

$(vQVPath)Master Files\D_GIS_DEPARTMENT_MSTR.xlsx

(ooxml, embedded labels, table is Sheet1);

GIS_REQUISITION:

LOAD

REQ_NO,

REQ_NO as REQ_NO_Req,

REQ_DATE,

REQ_DATE as TempDate_Req,

Date(Timestamp(REQ_DATE),'DDMMYYYY') as %KeyReqDate,

APPROVED_DATE,

HR_AGREED_DATE,

// GRADE_CODE,

DP_CODE as DEPARTMENT_CODE ,

ApplyMap("GIS_DEPARTMENT_MSTR","CLIENT_NAME", "Unknown") as REQ_Client_Name,

// SP_CODE,

BUILDING_CODE,

NUM_OF_PEOPLE_REQD,

D_REQ_STATUS,

If(Isnull(D_REQ_STATUS), 1,0) as OpenFlag,

If(Isnull(D_REQ_STATUS), 'Open','Closed') as OpenDesc,

D_RECRUITER_ID,

D_REQ_CLOSED_DATE

FROM

$(vQVPath)DATA Files\D_GIS_REQUISITION.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: MAPPING requires 2-column input!!!!

JonnyPoole — Tue, 19 Aug 2014 16:43:39 GMT

The error is accurate because the table with your mapping load has 5 columns and not 2 columns. 1 of the columns is the find column, the other is the replace.

-------

The mapping prefix is used to create a mapping table that can be used for e.g. replacing field values and field names during the script run.

It can be put in front of a Load or Select (SQL) statement and will store the result of the loading statement as a mapping table. A mapping table consists of two columns, the first containing comparison values and the second containing the desired mapping values. Mapping tables are stored temporarily in the memory and dropped automatically after the script execution.

Re: MAPPING requires 2-column input!!!!

Tue, 19 Aug 2014 16:44:50 GMT

Mapping table can have only two fields. Try this

GIS_DEPARTMENT_MSTR:

Mapping

LOAD

DEPARTMENT_CODE ,

CLIENT_NAME

FROM

$(vQVPath)Master Files\D_GIS_DEPARTMENT_MSTR.xlsx

(ooxml, embedded labels, table is Sheet1);

But keep in mind that if there are multiple Client Names for One department code, it will just pick the first name.