Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator 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
Anil_Babu_Samineni

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)

View solution in original post

12 Replies
nareshthavidishetty
Creator III
Creator III
Author

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

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)
nareshthavidishetty
Creator III
Creator III
Author

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

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)
kamalqlik
Partner
Partner

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
Creator III
Creator III
Author

Hi ,

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

Thanks..

qliksus
Specialist II
Specialist II

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?

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)
nareshthavidishetty
Creator III
Creator III
Author

Hi Anil,

Below is the sanapshot of data model.

Capture.PNG

Attached is the script.

Thanks