topic Re: link table creation between facts in QlikView

link table creation between facts

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: link table creation between facts

nareshthavidishetty — Mon, 15 Jan 2018 08:34:39 GMT

Hi,

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

Thanks..

Re: link table creation between facts

Anil_Babu_Samineni — Mon, 15 Jan 2018 08:44:13 GMT

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

Re: link table creation between facts

nareshthavidishetty — Mon, 15 Jan 2018 09:30:14 GMT

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

Anil_Babu_Samineni — Mon, 15 Jan 2018 09:32:36 GMT

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

Re: link table creation between facts

kamalqlik — Mon, 15 Jan 2018 09:35:18 GMT

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

Re: link table creation between facts

nareshthavidishetty — Mon, 15 Jan 2018 09:58:17 GMT

Hi ,

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

Thanks..

Re: link table creation between facts

qliksus — Mon, 15 Jan 2018 10:23:37 GMT

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

Anil_Babu_Samineni — Mon, 15 Jan 2018 10:47:38 GMT

Have you tried atleast?

Re: link table creation between facts

nareshthavidishetty — Mon, 15 Jan 2018 11:42:36 GMT

Hi Anil,

Below is the sanapshot of data model.

Attached is the script.

Thanks

Re: link table creation between facts

Anil_Babu_Samineni — Mon, 15 Jan 2018 11:44:15 GMT

Can you post 2 excel files?

Re: link table creation between facts

nareshthavidishetty — Mon, 15 Jan 2018 12:17:21 GMT

Hi Anil,

Kindly find the attached spread sheet with sample data.

Thanks..

Re: link table creation between facts

Anil_Babu_Samineni — Mon, 15 Jan 2018 12:43:12 GMT

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.