Join 2 tables using a node with LIKE

Hi,

I want to join columns from 2 tables from 2 different nodes. I want to filter and join using a node and matching string from 1 table to another table’s column

Where

Substr(Table1. column1,5) like (%Table2.Column2%)

Thanks,

RDS