Forum Discussion

zzzzoooo's avatar
zzzzoooo
Frequent Visitor
9 years ago

How to merge some columns in different tables ?

Hi,

 

Could you please tell me how to combine some columns in different tables together. For example, table X has columns A, B and C; table Y has column A, B and D; table Z has column A, B and E; and I'd like to take columns A and B from tables X, Y and Z. It seems that I can't use "Append Queries", nor "Merger Queries".

 

Thank you.

1 Reply

  • WanderingBI's avatar
    WanderingBI
    Icon for Resolver III rankResolver III
    2 years ago

    Hi! 

     

    Appending the queries should work. Lets say you have the following example tables:

     

    Table X:

    Table Y

    Table Z

     

     

    Create a reference to TableX (or any other table):

     

    Then append queries like so:

     

    You will then get the following output:

     

    Please let me know if it worked for you.