Discussion Board for collaboration on QlikView Scripting.
I am new to QV.
I have tried this for few days.
However, I couldn't complete this from the top to bottom.
basically, I would like to map phone call records with sales order based on call operator and time stamp.
(call Operator can't accept 2 different calls at the same time.)
here is the sample.
In this senario, first call needs to be mapped with Order-SD123
second call - SD124 and last call should have no order against it.
Can any one pleas give me an idea how i can resolve this?
any comment will be valuable.
Go to Solution.
Use Alt and multiple timestamp formats according to your input
Load OrderID,Timestamp#(Createdtime,'YYYY-MM-DD hh:mm') As Createdtime,Operator Inline [
SD123,2014-10-29 16:01,John Smith
SD124,2014-10-29 16:01,Jim Parker ];
Load Timestamp#(CallStarttime,'YYYY-MM-DD hh:mm') As CallStarttime,Timestamp#(CallEndtime,'YYYY-MM-DD hh:mm') As CallEndtime,Operator Inline [
2014-10-29 15:51,2014-10-29 16:10,John Smith
2014-10-29 15:51,2014-10-29 16:02,Jim Parker
2014-10-29 16:14,2014-10-29 16:18,John Smith];
INNER JOIN (SalesOrder)
IntervalMatch (Createdtime,Operator) Load CallStarttime,CallEndtime, Operator Resident CallRecord;
Join (SalesOrder) Load * Resident CallRecord;
Drop Table CallRecord;