Multiple date fields in single table

[divya_anand]

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.

[marcus_sommer · Accepted solution]

Have a look on this:

Canonical Date

Why You sometimes should Load a Master Table several times‌

- Marcus

[#3]

Hi,

When u have multiple date fields use conicaldates

[avinashelite]

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 .