Matching transaction to a mapping table with multiple criteria

Hello,

I am tyring to map a transaction table to a mapping table that have mutliple criteria

The mapping table looks like this

The transactions table looks like this

The objective is to map the transaction based on matching all criteria in the mapping to calculate the sum (Amount_FCY) and count (# of Transaction that matches the criteria) for each row

I am trying to use Table.SelectRows but with little success unless there is an exact match,

Thanks