Join command using concat and substring

Hi there, I would like to create a join in Exploratory where I would like to concatenate 2 columns in table 1 and join that with a substring for 1 column in table 2. How can I achieve this in Exploratory without having to pre-process the data?