Intervalmatch, Syn table and loop with loosely coupled tables
I have the following issue and feel the solution is close but simply can get it.
I am trying to build a report on Part Numbers. Part Numbers are parts of ProductID, which then are parts of ProductGroupID. The Orders table gives the OrderDate and the ProductGroupID. The ProductHistory table gives which ProductID belongs to which ProductGroupID between which periods (StartDate and EndDate). The Product table gives the ProductID and the PartName.
Product: LOAD ProductID, PartName; LOAD * INLINE [ ProductID, PartName 1, A 1, B 1, C 1, D 1, E 2, F 2, G 3, H 3, I 3, J 3, K 4, L 4, M 4, N ];