EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » merge
transformations:merge

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
transformations:merge [2023/10/11 20:49] – [Remarks] craigttransformations:merge [2024/04/11 23:55] (current) – add inner join craigt
Line 7: Line 7:
 This action appends one or more columns from another table where the values in certain columns in both tables match. The action is similar to the SQL join. This action appends one or more columns from another table where the values in certain columns in both tables match. The action is similar to the SQL join.
  
-There are three possible merge modes:\\+There are four possible merge modes:\\
    
 ====Lookup Mode==== ====Lookup Mode====
Line 17: Line 17:
 ====Full Join Mode==== ====Full Join Mode====
 Include all combinations of keys from both tables. Similar to the full outer join in SQL.\\ Include all combinations of keys from both tables. Similar to the full outer join in SQL.\\
 +\\ 
 +====Inner Join Mode====
 +Include only matching rows from both tables.\\
  
 \\ \\
Line 23: Line 26:
   * (Left Join Mode) Blend in additional data from other tables into the primary dataset.   * (Left Join Mode) Blend in additional data from other tables into the primary dataset.
   * (Full Join Mode) Combine two entire datasets to be cleaned and consolidated downstream.   * (Full Join Mode) Combine two entire datasets to be cleaned and consolidated downstream.
 +  * (Inner Join Mode) Connect only rows from both tables where the values in the selected fields match.
  
 \\  \\ 
Line 29: Line 33:
 |Add columns from table|Select table that will return columns to the current dataset where values match.| |Add columns from table|Select table that will return columns to the current dataset where values match.|
 |Where all these columns match|Select the columns within the current dataset (left drop-down) and the second dataset (right drop-down) where\\ values will match.  To define multi-columnar matches, use the //Add more matching columns// to select additional matching columns in each dataset.| |Where all these columns match|Select the columns within the current dataset (left drop-down) and the second dataset (right drop-down) where\\ values will match.  To define multi-columnar matches, use the //Add more matching columns// to select additional matching columns in each dataset.|
-|Merge mode|Options:\\  //Lookup// (for each row in this table, get any one matching row from the second table and ignore other matches),\\ //Left join// (for each row in this table add all matching rows from the second table),\\ //Full join// (add matching and non-matching rows from both tables).|+|Merge mode|Options:\\  //Lookup// (for each row in this table, get any one matching row from the second table and ignore other matches),\\ //Left join// (for each row in this table add all matching rows from the second table),\\ //Full join// (add matching and non-matching rows from both tables)\\ //Inner join// (add rows that match in both tables).|
 |Return columns|From the list, select the columns from the second dataset that will be appended to the current dataset.| |Return columns|From the list, select the columns from the second dataset that will be appended to the current dataset.|
 The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window. The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window.
transformations/merge.txt · Last modified: 2024/04/11 23:55 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki