Sort out the different between 2 unrelated tables

[Anonymous]

Hi,

I have the 2 Tables as the attached pbix . Support.pbix

I would like to sort out the different Lines in the 2 table Line and Port. 

In Table port, on production there is 541  or 543 or 544 different lines, in the meanwhile there is only 65 lines. 

Thank you in advance for your help.

Tg 

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

[Anonymous]

Hi @lbendlin 

Thank you for your reply. 

What I can achive is the 2 matrix in screenshot.

I would like to have 2 same matrix as screenshot that list ONLY the different LINES between 2 tables .

• Sub-section CATT :
  • PRD (Table Port) = 545
  • Prod_CATT (Table Line) = 16
  • Ex : There are 535 Lines in Table Port unavailable in Table Line, and there are 6 Lines in Table Line unavailable in Table Port
• Sub-section COMMU :
  • PRD (table Port) = 1085
  • Prod_commu (Table Line) = 65
  • Ex : Ther is 1020 lines in table Port unavailable in Table Line, and all 65 lines of Table Lines found in Table Port
•