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

[nareshthavidishetty]

Hi,

Any help.I have been confused while creating the link table for the above tables.

Thanks..

[Anil_Babu_Samineni]

You should clear about why you want to use Link Table. Anyway, PFA

[nareshthavidishetty]

Hi Anil,

Thanks for the reply.

I belive the script attached will give more synthetic keys,synthetics tables.

Thanks

[Anil_Babu_Samineni]

Don't think so, Can you share image of model after reload the script? Then we can discuss the same

[kamalqlik]

Hi Naresh,

Please use the given link https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

for your query solution.

Regards

Kamal

[nareshthavidishetty]

Hi ,

In the script you have called the same files using resident.

Thanks..

[qliksus]

Simply joining by the common fields should be fine in your case . You can join based on

Plant_Id, Material_Id, Plant_Material_Id ,Supplier_Id  by using Auto number function

[Anil_Babu_Samineni]

Have you tried atleast?

[nareshthavidishetty]

Hi Anil,

Below is the sanapshot of data model.

Attached is the script.

Thanks