Scenario

Where we have two sources of data that share the same structure we can combine these into a single table without the need to perform a merge. The intention is that we will keep all records so for every record we pass in we will get one out.

For example, if we are performing a data migration where we are consolidating data from 3 separate systems that all follow the same data structure we can use this technique. 

Solution

1. It is assumed that all data sources are imported into their own tables in an analysis model.
2. From the Create section of the analysis toolbar, click  Show Tables

   1. drag the  Merge Table  onto your model.

   2. In the settings, set the Name for example Businesses Merged

   3. The attributes can be created manually using the plus button in the Attributes section. Here we will use the attributes from the Businesses 1 table to automatically setup our merge attributes.

      1. Hover over the Businesses 1 table and from the hover over toolbar click  Show or Hide Attributes.

      2. Tick all of the attributes and then drag them into the attributes section of the Merge Table. 

      3. If PhixFlow asks for confirmation. Select Use original attribute name. Then click the arrow  to confirm.
         

   4. Click  OK to save and close the settings for the merge table.

   1. Connect the Inputs

      1. In the analysis model, hover over the Businesses 1 table.

      2. From the hover over toolbar, select  Connector, then click the end of the arrow onto the merge table. This connector will pipe data into the merge table.