Search results

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.

    create expression

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

    select expression column

  3. Click Merge to join the tables.

    click merge button

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

    joined columns are shown in table

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