Mapping Load

[#1]

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.

[Anonymous · Accepted solution]

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

[#3]

Hi

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

[#4]

Thanks a lot Bill.