Forum Discussion
Merge or Append Queries?
Anonymous - You can merge on multiple columns using Ctrl or Shift to select
Anonymous - Can't access file. Generally this sounds like an Append. Are you sure that your column names, including the value column are all identically named? If you Append with all the same column names, you should not end up with 2 values columns.
I made the column names identical and you are correct, I did not end up with an additional value column. However, I am thinking that I am going to need to merge instead if I am aiming to add additional columns that contain the values of my other queries. When I merge and match the Dept-ID using Left Outer Join and expand only the Value column, my Dept-ID and Department rows duplicate. Here is a snip just so you have an idea of what I am looking at.
Anonymous - You can merge on multiple columns using Ctrl or Shift to select
This is correct how it is in the snip, but once i merge, those two columns (Dept-ID and Department) go on for hundreds of rows. Also, my weeks columns has 'Week 1' for 52 rows for the same Dept-ID and Department.