Select rows from another table that match value of a column in this table

[Anonymous]

I need to be able to reference a subset of another table/query (inputTable) in my current table/query (currentTable).

I have tried:

= Table.AddColumn(#"prev step", "SubsetTable", each Table.SelectRows(inputTable, each Record.Field(_, colA) = [A] and Record.Field(_, colB)=[B]))

I want the rows from the inputTable where colA (and colB) match the values in column A (and B) in the current table in the current row (/for each row)

Hope this makes sense

[HotChilli · Accepted solution]

Merge?

[Anonymous]

Of course 🙈

thnx