Bold BI allows joining tables based on the expression columns created.
Create an expression for joining the tables and click
Save. The below expression used to split the employee name from Email column in the Employee table and joining the Employee table with EmployeesProfile table.
Select the column created in previous step under expression.
Merge to join the tables.
Joined tables are displayed based on the Expression column when you click
Note: When choosing the expression columns, aggregate expressions are restricted.