# Join command using concat and substring

**URL:** <https://community.exploratory.io/t/join-command-using-concat-and-substring/1802>\
**Category:** Uncategorized\
**Created:** [February 24, 2020, 8:56pm UTC](https://community.exploratory.io/t/join-command-using-concat-and-substring/1802 "2020-02-24T20:56:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Natarajan\_Kalvai\_Ven](https://community.exploratory.io/user_avatar/community.exploratory.io/natarajan_kalvai_ven/32/797_2.png) [@Natarajan\_Kalvai\_Ven](https://community.exploratory.io/u/Natarajan_Kalvai_Ven)\
**Post date:** [February 24, 2020, 8:56pm UTC](https://community.exploratory.io/t/join-command-using-concat-and-substring/1802/1 "2020-02-24T20:56:19Z")

</div>

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?