Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
try something like:
DateTemp:
LOAD
Date
Resident Calendar;
LINKTABLE: // <------------------- fix the name
LOAD
StartDate,
EndDate,
FlowCaseActivityID
RESIDENT FlowCaseActivityTemp;
LEFT JOIN
IntervalMatch(Date)
LOAD
StartDate,
EndDate
RESIDENT FlowCaseActivityTemp;
drop table DateTemp; // <------------ delete unused table
Thanks for your answer. Actually I allready tried that without success.
But when I change place of Date and LinkTable it worked:
ActivityLinkTable:
LOAD
StartDate,
EndDate,
FlowCaseActivityID
RESIDENT FlowCaseActivityTemp;
DateTemp:
LOAD
Date
Resident Calendar;
LEFT JOIN (ActivityLinkTable)
INTERVALMATCH (Date)
LOAD
StartDate,
EndDate
RESIDENT ActivityLinkTable;
Drop
Table DateTemp;
Hi, now I have a new problem with the same example as above.
The Dates I am using includes date + Time. Therefore I used:
Date(StartDate,'YYYY-MM-DD') as StartDate
Result:
The ActivityLink-table now skip the first date in the period, In other words:
StartDate=2008-10-17 EndDate=2011-08-02 ( The first) Date= 2008-10-18
When I try and use Floor(Date(StartDate,'YYYY-MM-DD')) instead I get 6 multiple rows in the table for each row.
I don´t know why, do anyone have an explanation to this?
Thanks!