Forum Discussion
Merge or Append Queries?
I have multiple queries that have all the same columns except for the values column. I am wanting to combine the value columns from the different queries into one query and of course have my DIM tabl...
Anonymous - You can merge on multiple columns using Ctrl or Shift to select
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