Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have used the below code. Applymap is not working for me and returning 'na'
Calendar:
LOAD TIME_PERIOD_YEAR,
TIME_PERIOD_WEEK_NO,
Date(TIME_PERIOD_START_DATE,'DD/MM/YYYY') as PERIOD_START_DATE,
TIME_PERIOD_PERIOD,
CALENDAR_MONTH_NUMBER,
TIME_PERIOD_QUARTER_NO
FROM
(biff, embedded labels, table is [Sheet1$]);
STORE Calendar into Calendar.qvd(qvd);
Mapping
Cal_Map:
LOAD
PERIOD_START_DATE as date,
TIME_PERIOD_PERIOD as Period
Resident Calendar;
Data:
LOAD [Customer Sector],
[Customer Region],
[Customer Market],
[Incident #],
Field_Category,
Priority,
Impact,
Urgency,
[Division(s)],
[Incident Type],
Status,
Environment,
[MTTr - HHMMSS],
[MTTr - H.hh],
[MTTr - SLA],
[MTTR - HHMMSS],
[MTTR - H.hh],
[MTTR - SLA],
[MTTR - SLA Text],
[Assignment Group],
Assignee,
[Assignment Area],
[Assignment Sub-Area],
[Open Time],
[Open Year],
[Open Month],
[Open Week],
[OwnerGroup Group],
Owner,
[Respond Time],
[Respond Year],
[Respond Month],
[Respond Week],
[Resolved Time],
Date(Timestamp#([Resolved Time],'YYYY/MM/DD hh:mm:ss'),'DD/MM/YYYY') as Resolved_Date,
ApplyMap('Cal_Map',Date(Timestamp#([Resolved Time],'YYYY/MM/DD hh:mm:ss'),'DD/MM/YYYY'),'na') as Resolved_Period,
[ReOpened Time],
[ReOpened Year],
[ReOpen Month],
[ReOpened Week],
[ReOpened By],
[Resolved Year],
[Resolved Month],
[Resolved Week],
[Resolved Group],
[Resolved By],
[Closed Time],
[Closed Year],
[Closed Month],
[Closed Week],
[Closed Group],
[Closed By],
[Customer Location],
Title,
Description,
System,
[Service Component],
[Sub Service Component],
[Affected CI],
Vendor,
[Closure Code],
[Soution ID],
[Knowlix Title],
[Customer Last Name],
[Customer First Name],
[Customer Title],
[Customer VIP],
DeptID,
Hops,
[StarTeam CR Number],
[StarTeam Flag],
ProjectNumber,
[Assist Group1],
[Assist Assignee 1],
[Assist Status 1],
[Assist Group 2],
[Assist Assignee 2],
[Assist Status 2],
Generic,
[R7 Incident Flag],
[Missed SLA Reason],
[Ebonding Number],
[Ebonding Category],
[Ebond To],
[Ebond Group],
[Ebond Source],
WorkAround_Impl,
Sol.Appl.By,
[Can Customer Solve ?],
[Incident Flag],
[Result of Change],
[Incident Location],
[Priority Increased],
[Priority Decreased],
[Outage Start],
[Outage End],
Workstation,
Model,
Resolution,
[SAP Solution Type],
[SAP Control Impacted],
[SAP Control Type],
[SAP Control Number],
[SAP Table Impacted],
[SAP Transport ID],
Route,
SLA_BREACH,
[SLA Name],
[SLA Expire]
FROM
(biff, embedded labels, table is [Data$]);
store Data into Data.qvd(qvd);
Please let me know where I am wrong.
Thanks,
Varsha
Hi Varsha
it would be definitely due to date fields, is it possible to have sample data
regards
padma
Hi Padma,
Please find the attached excels.
Thanks,
Varsha
Hi, Varsha.
If this is still an outstanding issue for you, have a look at this blog for help.
http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
If you have resolved this, please mark this post as resolved so that other people can use your solution.
Thanks,
Neil
Hi Neil,
I had checked this above blog before. I felt it was because of the date field so I split the date field and then concatenated and then used apply map, its working as required.
Regards,
Varsha