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

• It is assumed that all data sources are imported into their own tables in an analysis model.
• We will refer to all tables that are due to be combined as input tables and the table where the data is being combined as the output table. 

1. From the Create section of the analysis toolbar, click  Show Tables

   1. drag the  Calculate Tableonto your model.

   2. In the settings, set the Name.

2. For each of the input tables, from its hover over toolbar, select  Connector, then click the end of the arrow onto the output table.

3. Hover over the first input table and from the hover over toolbar click  Show or Hide Attributes.

   1. Tick all of the attributes and drag them onto the output table. 

      1. If PhixFlow asks for confirmation. Select Use original attribute name. Then click the arrow  to confirm
         
   2. This automatically creates the attributes for us in the output table.
4. We now need to set the attributes up to pull information from all input tables.
   1. Click on the output table, in its Attributes section double click the first attribute
   2. Remove the pipe prefix, typically this will be "in.". By doing this we are telling PhixFlow to look for this attribute name regardless of which pipe it is coming from.
      1. For Example, in.CompanyName would become CompanyName.
   3. Repeat this for all of your attributes, the configuration is illustrated below:
   4. 
   5.  

5. Click  OK to save and close the settings for the output table.