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