Helical Insight automatically identifies all the already existing joins, type of joins and columns used in current connection. Over and above that a user has the option to create new joins between any column of any table. Click on “Add“, select the left and right column, select the type of join from drop down list and this way you can add a new join.
Existing join types can also be edited by clicking on join.
By clicking on column, you can either discard the column and use any other column from metadata. You can also swap columns as shown. You can also delete a join by clicking on either delete button or clicking discard join or checking and use Delete Selected.