Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a single table data with 4 date fields (Created, Assigned, Target, Completed). how can I deal with this in connecting to the Master Calendar?
Thank you.
Hi,
When u have multiple date fields use conicaldates
create a LINK table , to connect for the Master calendar.
Try like this :
Master:
LOAD
Created,
Assigned,
Target,
Completed,
Key
....
LINK:
LOAD Key,
Created as Date_Key
resident
Master;
LOAD Key,
Assigned as Date_Key
resident
Master;
LOAD Key,
Target as Date_Key
resident
Master;
LOAD Key,
Completed as Date_Key
resident
Master;
Calendar:
LOAD Date as Date_Key,
.....
NOTE: keep all the dates in same format
Hope this helps you .