Data Union Suggestions and Settings

Starting in Strategy (November 2026), you can create a union between two or more tables from the same or different data sources. Use data unions to combine tables with matching columns into one logical table. You can customize the table such as choosing to keep all rows or remove duplicates, allowing missing columns, and more. You can also edit or split the union later. Prepare, model, and publish the resulting table as you would any other table, without writing custom SQL.

Apply a Data Union Suggestion

  1. Create and add tables to your Mosaic model.

  2. In the top navigation in Sources and Prep, click Suggestions.

  3. Scroll to a Data Union suggestion and click Apply .

    The union table is automatically created, connects to the source tables, and displays an automated summary of the table behavior.

Edit Data Union Table Settings

  1. Hover over the newly created union table in the center map and click Edit .

  2. In Table Name, type a display name for the table.

  3. In Union Tables, view the connected tables. To add more tables:

    1. Click Add Table.

    2. In Select or Search, find and select your table.

    3. To remove a table from the union, hover over it and click Delete .

  4. In Merge Method, choose from the following options:

    • Distinct: Select this option to combine rows of similar values into one.

    • All: Select this option to display all rows including duplicate rows.

  5. In Advanced, optionally select the check box next to the following settings:

    • Union by name: Select this option to combine columns by name rather than position in the table.

    • Allow missing columns: Select this option to fill missing columns with a NULL value, rather than allowing the union table to fail with blank values.

  6. Click Apply.