Please help me out how to create a link tale between these below two fact tables.
FROM [..\5_QVD\QQQns.qvd] (qvd);
Calendar_Year as [Calendar Year],
Date(Floor(MonthEnd(Date#(Calendar_Year & '-' & Calendar_Month, 'yyyy-MM'))), 'DD-MMM-YYYY') as [Calendar Date],
FROM [..\5_QVD\aansssy.qvd] (qvd);
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.
You should clear about why you want to use Link Table. Anyway, PFA
Don't think so, Can you share image of model after reload the script? Then we can discuss the same
Please use the given link https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/
for your query solution.
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
Have you tried atleast?