Matching Dates

[#1]

Hi There,

Hoping someone can help point me in the right direction.

I'm loading two tables from QVD files.

LOAD [UserID],
CompanyID,
SiteID,
interval(EndTime-StartTime,'mm') as ScheduleDuration,
//ServiceID,
StartTime,
EndTime,
ScheduleTypeID
FROM
[Schedule.qvd]
(qvd);

LOAD WorkID,
CallID,
UserID,
CompanyID,
ServiceID,
EmployeeID,
// [UserID],
CallStateTypesID,
Priority,
WorkDate,
DateCreated,
DateUpdated,

FROM
[Work.qvd]
(qvd);

At the momment i have two separate Calenders based on the DateUpdated Field and the StartTime field. I would like to have one Calender in the Application. How can i go around joining the dates? Ive looked at the intervalmatch command but cant quite get it. Any help would be much appreciated. I'm using Qlik Version 9.0

Many Thanks

Gez

[#2]

But then doing this then the Date field within Schedule Doesnt Join

Thanks for your help with this!

[#3]

I wanted you to create the Calendar table like this:

LOAD
date(makedate(2009)-1 + recno(), 'DD-MM-YYYY') as Date,
date(makedate(2009)-1 + recno(), 'DD-MM-YYYY') as DateCreated
AUTOGENERATE 365;

This way, you will link with the first Table using Date, and Second Table using DateCreated

[#4]

Sorry I see, that Makes sense.

although when trying that I know get a script reload error, When stepping through it as it loads the calendar last it's just after this it now generates the "Execution of Script failed. reload old Data? Message.

Thanks again

[#5]

hmm..can't tell anything on that, unless you can post a sample qvw file.

[#6]

Thanks for all your help, will look to work my way back through it and post a scrambled file if i can't get to the bottom of it!

Cheers

Gez

[#7]

Thanks for all your help, will look to work my way back through it and post a scrambled file if i can't get to the bottom of it!

Cheers

Gez