topic Re: Mapping Load in QlikView

Mapping Load

Wed, 17 Dec 2014 13:56:42 GMT

Hi all,

Please look at the script below

Campaign:

LOAD

//Directory;

//LOAD

uniqueid as camp_UID,

createdon,

nam5 as campmastername,

expenditur1 as campexp,

descriptio2,

startdat6 as campstartdate,

enddat6 as campenddate,

isactiv7

FROM

[..\10_data_sources\tecampaignmaster.qvd]

(qvd);

Join(Campaign)

//*************Campaign Channel**************///

CampaignChannel:

//LOAD

//Directory;

LOAD

uniqueid as channeluid,

createdon,

nam4 as channelname,

expenditure as channelexp,

descriptio1,

startdat5 as channelstartdate,

enddat5 as channelenddate,

isactiv6,

channeltype,

campaignmaster as campname,

//ApplyMap('MAP_Campaign',[campaignmaster]) as campname1,

ApplyMap('MAP_Campaign',campaignmaster) as campname1,

channeltypesubcategory

FROM

[..\10_data_sources\tecampaign.qvd]

(qvd);

MAP_Campaign:

Mapping

LOAD Distinct camp_UID,campmastername Resident Campaign;

Exit Script;

I am expecting the result to be campmastername to be applied in campaignmaster field alias campname1 which I am not getting it. Can someone help me out here.

Re: Mapping Load

Anonymous — Wed, 17 Dec 2014 14:01:09 GMT

You need to do the Mapping Load before the ApplyMap()

Re: Mapping Load

Wed, 17 Dec 2014 14:04:54 GMT

MAP_Campaign:

Mapping

LOAD Distinct camp_UID,campmastername Resident Campaign;

Campaign:

LOAD

//Directory;

//LOAD

uniqueid as camp_UID,

createdon,

nam5 as campmastername,

expenditur1 as campexp,

descriptio2,

startdat6 as campstartdate,

enddat6 as campenddate,

isactiv7

FROM

[..\10_data_sources\tecampaignmaster.qvd]

(qvd);

Join(Campaign)

//*************Campaign Channel**************///

CampaignChannel:

//LOAD

//Directory;

LOAD

uniqueid as channeluid,

createdon,

nam4 as channelname,

expenditure as channelexp,

descriptio1,

startdat5 as channelstartdate,

enddat5 as channelenddate,

isactiv6,

channeltype,

campaignmaster as campname,

//ApplyMap('MAP_Campaign',[campaignmaster]) as campname1,

ApplyMap('MAP_Campaign',campaignmaster) as campname1,

channeltypesubcategory

FROM

[..\10_data_sources\tecampaign.qvd]

(qvd);

Mapping should be in first and next applymap like above

then only it works

Re: Mapping Load

Wed, 17 Dec 2014 14:06:50 GMT

Thanks a lot Bill.