Find substring and bring category

Hello, I would like to map the following situation:   There is table 1 with categories based on store names   and there is also table 2 with transactions   I would like to bring the ...