Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Merge query based on multi columns

I am looking to merge a table but i am trying to merge based on 2 parametars so for example if i have a column 1 to 10 then another column which is user bandings i need to be able to merge base on column 1 but also to furth filter the dataset to column 2. Is there an easy was to do this?

Need Help
Show and Tell

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi Anonymous ,

     

    When you merge two tables you can make it by more than one column you just need to be carefull on the order you select the columns.

     

    Two things to be carefull:

    • Use CTRL to select your columns
    • Be sure you match the numbers of the columns on both tables

     

    Small number highligted appears after selection of the columns with control and indicates the order of the columns if you change it you will get different results see image below:

     

     

    First example no matches second example since the first column don't have the same type it doesn't allow the match,.

     

    Regards,

    MFelix