Forum Discussion

Macwin's avatar
Macwin
Icon for Helper I rankHelper 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

Macwin's avatar
Macwin
Icon for Helper I rankHelper I
4 years ago

Thanks for the Reply 🙂 

 

I got the table created.  Is there a possibilty to filter this table like I mention it in the first post ?

for example as new bool column so i can use it for a visual slicer filter

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

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