Forum Discussion

jamiers's avatar
jamiers
Icon for Helper I rankHelper I
4 years ago
Solved

Remove row if it matches row in another table

Hello All,   I have been searching this question, but I can't seem to get to the bottom of my solution.   If an item shows up in Table 1, I want it to be excluded in Table 2.   I have created a...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Insert this statement in GAP Promotions - Promotions Lis where Table 2 is !GAPCheck

     

    = Table.SelectRows(Source, each not List.Contains(List.Buffer(Table2[#"Mem#/GAP"]),[#"Mem#/GAP"] ))

     

     

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

Here is a link to a Excel Sheet with Table Data.

Table Data

 

If a row shows up in !GAPCheck [Mem#/GAP], I want to eliminate the row from GAP Promotions - Promotions Lis.

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Insert this statement in GAP Promotions - Promotions Lis where Table 2 is !GAPCheck

 

= Table.SelectRows(Source, each not List.Contains(List.Buffer(Table2[#"Mem#/GAP"]),[#"Mem#/GAP"] ))

 

 

  • jamiers's avatar
    jamiers
    Icon for Helper I rankHelper I
    4 years ago

    Thank you.  That did it.