Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nareshthavidish
Contributor III

link table creation between facts

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

1 Solution

Accepted Solutions

Re: link table creation between facts

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.

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
12 Replies
nareshthavidish
Contributor III

Re: link table creation between facts

Hi,

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


Thanks..

Re: link table creation between facts

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nareshthavidish
Contributor III

Re: link table creation between facts

Hi Anil,

Thanks for the reply.

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

Thanks

Re: link table creation between facts

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Re: link table creation between facts

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

nareshthavidish
Contributor III

Re: link table creation between facts

Hi ,

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

Thanks..

qliksus
Valued Contributor II

Re: link table creation between facts

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

Re: link table creation between facts

Have you tried atleast?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nareshthavidish
Contributor III

Re: link table creation between facts

Hi Anil,

Below is the sanapshot of data model.

Capture.PNG

Attached is the script.

Thanks