6 Replies Latest reply: Nov 9, 2016 4:19 AM by Kamil Lewandowski RSS

    IntervalMatch complicated case; 2 common fields

    Kamil Lewandowski

      Hi.

      After days of learning and trying I give up.

      Case is like this: I have (actually two big fact tables)

      Fact table

      Statistics table

      Map table for location names

       

      Problem is: How to match statistical data to fact table by date and location although statistical table has more location than fact table. And connect it all to location map to analyze facts by time and location and statisitcs by time and location.

       

      I attach xls and qvf files.

      sum of Stat_value should be same for each month obiously and has value ot only for months and location existing in fact table but for all months and locations existing in stat table.

       

       

      Hope I explained it enough to solve it for some pro.

       

      Hope some pro will help me.