Scenario

Where we have two sources of data that share the same structure, i.e. the same attribute names, 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 passed in, a record is passed out.

This technique is useful when performing a data migration where we are consolidating that consolidates 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

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

   Insert excerpt
   _datasource_show_tables_datasource _show_tables nopanel true

   drag the  drop down on the analysis toolbar, click and drag a 

   Insert excerpt
   _table_calculate_table _table_calculate_table nopanel true

   onto  table on your model
   .
   1. In the settingsProperties, set the Name, e.g. Output Table

2. For each of the input tables, from its hover over toolbar, select 

   Insert excerpt
   _pipe _pipe nopanel true

   , then click the end of the arrow onto the output table.

3. Hover over the first input table and from the hover over popup toolbar click 

   Insert excerpt
   _attributes_show_hideicon _attributes_show_hideicon nopanel true

   .

4. Tick In the Attributes window, 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 Image Removed to confirm
   2. Click Confirm
      1. This automatically creates the attributes for us in the output table
      .
   3. Close the Attributes window
5. We now need to set up the attributes up to pull information from all input tables.
   1. Click on the output table , in its Attributes section and

      Insert excerpt
      _pin _pin nopanel true

       the tab to keep it open
   2. In the Attributes section, double click the first attribute
   3. Remove the pipe prefix, typically this will be "in."
      1. For example, in.CompanyName becomes CompanyName.
      2. 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.
   4. Repeat this for all of your attributes, the configuration is illustrated below:
   5. Image Removed
   6. Image Removed 
   Click Image Removed OK
   2. f
      Image AddedImage Added
6. Click 

   Insert excerpt
   _finish _finish nopanel true

    to save and close the settings for the output table.