Join two tables with one column having all values from both

[Anonymous]

empid	salary
1
2
3

empid	Name
2	John Doe
4	Jane Doe
5	Billy Bo

Then have a column called empid with a filter that has the drop down values:
Filter
1

2

3

4

5

[v-yuta-msft]

Hi Sanabia816 ,

Click query editor-> Append queries to append your tables into a new table, then click transform-> group by to remove the duplicate empid. Please check if this can work for your tables.

Regards,

Jimmy Tao