link table creation between facts

[nareshthavidishetty]

Hi,

Please help me out how to create a link tale between these below two fact tables.

[Fact Quality]:

LOAD

Conform_Id,

Trans_Code,

Conformed_stateID,

Location_Code ,

Plant_Id ,

Code_Group,

Material_Id,

Plant_Material_Id,

Unit_Code,

Supplier_Id,

Manufacturer_Id,

Number_In_Source,

Deletion_Flag ,

Calendar_Date,

Start_Date,

Nr_Of_Quality

FROM [..\5_QVD\QQQns.qvd] (qvd);

Fact_Movement::

LOAD Calendar_Month,

Calendar_Year as [Calendar Year],

Date(Floor(MonthEnd(Date#(Calendar_Year & '-' & Calendar_Month, 'yyyy-MM'))), 'DD-MMM-YYYY') as [Calendar Date],

Month_Material_Count ,

Month_Document_Count,

Movement_Type ,

Plant_Id,

Material_Id,

Plant_Material_Id ,

Supplier_Id

FROM [..\5_QVD\aansssy.qvd] (qvd);

Thanks

[Anil_Babu_Samineni]

Can you post 2 excel files?

[nareshthavidishetty]

Hi Anil,

Kindly find the attached spread sheet with sample data.

Thanks..

[Anil_Babu_Samineni · Accepted solution]

This case, I don't think so whether you want to use LinkTable. So, again you are forcibly doing to create headache until unless needed. Anyway, Try this way.