Can different dates from different table be linked in a already linked Table?

[Anonymous]

In this Datamodel you can find Master Calender _InvoicedDate and  Master Calender_StartDate for InDate and SDate respectively.

which are connected to Linked Table

So I am not able to connect these both dates.

Actually I tried It but while naming them as T_Date or same name in the DATA LOAD EDITOR they are not fetching the approproate Data from the Table.

Tried WIth Converting them into Same Date order But also it did'nt Worked!

Please Let Me knw Is there a Way out to combine them as a single individual connected to the Linked Table and Can be used for searches.

as The Year Filter which i will use Should Use all the Required dates and display Proper Records.

Thank you

Prakhar Khandelwal

[YoussefBelloum]

Hi,

read this carefully

Canonical Date

and also this:

Linking to two or more dates

[Anonymous]

Thank you For Such An Effort

But there is A problem when I just Remane then as T_Date or SImilar Date.

you can relate from ur example that

The Date and DateType

when OrderDate and ShippingDate is renamed to Date then It automatically combines the Date.

Here there is no joins used but Still it is connecting...

while In my Script (Showen Below):

Please Find the Mistake in the Below Linking:

P.S.: Payment Milestone , Payment Details are connected 1st then

AMCPayment and AMCDetails are connected

to Project,CLient and ConversionID

Otherwise I was not able to connect the Following in the Look Up Table...

//Linked Table

NoConcatenate

Linked_Table1:

LOAD

           ClientId

Resident Client;

Left join

LOAD Distinct

          [%ProKey],

          Project_ClientID as ClientId,

          ConversionFactorID as ConversionID

     ,     "Kick-off"    // The Date to Connect

Resident Project;

left join

Load

          [%PCostKey],

          ProjectCost_ProjectID as [%ProKey]

  Resident ProjectCost;

left join

LOAD  Distinct

           [%PaymentMilestoneKey],

           PaymentMilestone_ProjectID as [%ProKey]

//            ,Date(MilestoneCompleteDate,'DD-MM-YYYY') as T_Date   The Date to Connect

//            ,'Milestone ' as DateType

  Resident PaymentMilestone;

left join

LOAD Distinct

         [%PaymentDetailsKey],

         PaymentDetails_MilestoneID as [%PaymentMilestoneKey]

        InvoicedOn // the Date to Connect

Resident PaymentDetails;

left Join

Load

           ConversionID

Resident Conversion;

left Join

LOAD

           %CustomizationKey

,          Customization_ProjectID as [%ProKey]

Resident CustomizationCost;

//---------------------------------------

//Linked Table2

Linked_Table2:

LOAD

           ClientId

Resident Client;

Left join

LOAD

            [%ProKey],

            Project_ClientID as ClientId,

            ConversionFactorID as ConversionID

  Resident Project;

left Join

Load

            [%AMCDetailsKey],

            AMCDetails_ProjectID as [%ProKey]

Resident AMCDetails;

left Join

LOAD

            [%AMCPaymentKey],

            AMCPayment_AMCDetailsID as [%AMCDetailsKey]

            StartDate  // the Date to Connect

  Resident AMCPaymentDetails;

left Join

Load

           ConversionID

Resident Conversion;

NoConcatenate

Linked_Table:

  LOAD

            [%ProKey],

            ClientId,

            ConversionID,

            [%CustomizationKey],

            [%PCostKey],

            [%PaymentDetailsKey],

            [%PaymentMilestoneKey]

  Resident Linked_Table1;

DROP table Linked_Table1;

  Concatenate(Linked_Table)

LOAD

            [%ProKey],

            ClientId,

            ConversionID,

            [%AMCDetailsKey],

            [%AMCPaymentKey]

  Resident Linked_Table2;

DROP table Linked_Table2;

// Call Calendar Generator for field "Date"

//CALL CalendarFromField('T_Date', 'CommonCalendar', '');

CALL CalendarFromField('Kick-off', 'ProjectCalender', 'Project ');

CALL CalendarFromField('MilestoneCompleteDate', 'MilestoneCalendar', 'Milestone ');

CALL CalendarFromField('InvoicedOn', 'InvoiceCalendar', 'Invoice ');

CALL CalendarFromField('StartDate', 'AMCCalendar', 'AMC ');