Forum Discussion
jamiers
Helper I
Helper IRemove 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...
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"] ))
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalPlease post samples of Table1 and Table2 so that we can provide the solution.
jamiersHelper I
Helper IHere is a link to a Excel Sheet with 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
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
Thank you. That did it.