PQ Filtering Tables within a column of Tables

[cr731]

I have a table with a column of text values and a column of tables,

Value I Want to Exclude	Column of Tables
one	Table
two	Table
three	Table

<tbody>
</tbody>

For the "Column of Tables," those tables will contain a column with values corresponding to the "Value I want to exclude" column - and I want to filter those tables to remove the row that matches the Value I Want to Exclude. So for line one, the Table in Column of Tables may look like

Value to Match	Col1	Col2	Col3
five	xx	xx	xx
one	xx	xx	xx
seven	xx	xx	xx

<tbody>
</tbody>

For this table, I'd like to SelectRows and remove "one" since it is the value matching on that row of overall table. I tried adding a custom column like this

Table.SelectRows([Column of Tables], each [Value to Match] <> [Value I Want to Exclude]

but I get an error because the [Value I Want to Exclude] column is not part of the [Column of Tables] table, and I can't figure out how to access fields from the overall table in the SelectRows formula.

The other idea I had was to use an anti join but I don't want it to be applied against the whole table, just on a row by row basis.

 

[MarcelBeug]

You were quite close with adding the column. The entire line of your code probably looks like this:

StepName = Table.AddColumn(PreviousStep,"NewColumn", each Table.SelectRows([Column of Tables], each [Value to Match] <> [Value I Want to Exclude]))

You can change this to something like:

StepName = Table.AddColumn(PreviousStep,"NewColumn", ([B]MainTable) => [/B]Table.SelectRows([Column of Tables], each [Value to Match] <> [B]MainTable[/B][Value I Want to Exclude]))