Merge 2 columns from 2 different tables with different structures

[stranter]

Hi,

I'm not sure where to begin with what I want to do.  I have two tables, of differing structures, but with one column which is the same.  I want to combine this column in a seperate table and remove the duplicates:

I'm not sure where to begin so any suggestions are welcome!

Thanks,

Stewart

[ryan_mayu · Accepted solution]

@stranter

Maybe you can try this code. Thanks.

Table = 
VAR regis=values(Table1[ID])
VAR app=VALUES(Table2[ID])
return DISTINCT(UNION(regis,app))

[v-yuta-msft · Accepted solution]

@stranter,

Power Query can also achieve your requirement, please refer to steps below:

1. Click query editor-> Merge as new-> select Full Outer.

  

2. Expand by ID column of application and remove the useless column.

 

3. The result will be like below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu · Accepted solution]

@stranter

Maybe you can try this code. Thanks.

Table = 
VAR regis=values(Table1[ID])
VAR app=VALUES(Table2[ID])
return DISTINCT(UNION(regis,app))