This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
View solution in original post
Any help.I have been confused while creating the link table for the above tables.
You should clear about why you want to use Link Table. Anyway, PFA
Thanks for the reply.
I belive the script attached will give more synthetic keys,synthetics tables.
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.
In the script you have called the same files using resident.
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?
Below is the sanapshot of data model.
Attached is the script.