Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You need to do the Mapping Load before the ApplyMap()
You need to do the Mapping Load before the ApplyMap()
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
Thanks a lot Bill.