Joseph on 25 Apr 2017 23:33:27
QlikView supports this via its LEFT/RIGHT KEEP commands. Basically, if I have a Calendar and an Order tables, and the Order.Date is linked to Calendar.Date, then I would like to load only Order records with matching Order.Date and Calendar.Date. This would ensure data consistency in my data model automatically and eliminate to load too many data not needed. I would like feature to be supported, if possible. Thanks.