Forum Discussion
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 ...
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.
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.
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.