Forum Discussion

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago
Solved

Data modelling, map weekly table to Monthly table

Hi Guys,   I have table A which runs weekly, and table B that runs monthly.    I need to do weekly calcualations using Monthly figures, how do I do this?     I'm not gonna say how I did it, as ...
Need Help
  • KH11NDR's avatar
    KH11NDR
    8 years ago

    I've got it working, I had to a 4 field match In original merge and then 5 field match on the third table merged in with the original data and do a full outer join on all merges.

Ruksuro's avatar
Ruksuro
Icon for Helper III rankHelper III
8 years ago

If this is the same data I would just have two date columns, one with the date and one with monthstart(date).

 

Best practice would be a date table linked on date but this is not always necessary.

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago

It's a dummy dataset

 

I did something similar to your suggestion, plus I added a year field, but I'm not getting the results I need, I've tried Append, Merge and Many to Many.

 

I get one set of values but 0 for the second set.