Exploratory Community

Join command using concat and substring

#1

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?