Forum Discussion

Macwin's avatar
Macwin
Helper I
4 years ago
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...
Need Help
Tutorial Requests
  • johnt75's avatar
    johnt75
    4 years ago

    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)
)
  • johnt75's avatar
    johnt75
    4 years ago

    In the SELECTCOLUMNS you can create a column which specifies which table it comes from, you could then filter on that