Forum Discussion
Solved
Table merge with a specific Condition
Hello Guys, I have a problem and currently dont know how to resolve this problem. I have two Tables. Table A = Active Order Lines Table B = Archived Order Lines Now we need to merge this two t...
You can't do a simple UNION between the tables as there appear to be different columns between the tables, however you can use SELECTCOLUMNS to build a table with the required columns, something like
New Table = var documentNumArchived = EXCEPT( VALUES(Archived[Document no]), VALUES(Active[Document no]) ) return UNION( SELECTCOLUMNS( Active, column list here), CALCULATETABLE( SELECTCOLUMNS(Archived, column list here), documentNumArchived) )In the SELECTCOLUMNS you can create a column which specifies which table it comes from, you could then filter on that
Hi Macwin ,
Table 1
Table 2
You can use the merge operation in Power Query Editor.
You can choose the join kind you want. Here's an official document for reference.
If you want to display rows with the same Document No in both tables, you need to select Inner kind.
Results:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.