Merge query based on multi columns

[Anonymous]

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?

[MFelix]

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