Joining tables based on expression column

Bold BI allows joining tables based on the expression columns created.

1. 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.

   

2. Select the column created in previous step under expression.

   

3. Click Merge to join the tables.

   

4. Joined tables are displayed based on the Expression column when you click Update or Data preview.

   

Note: When choosing the expression columns, aggregate expressions are restricted.