User Tools

Site Tools


transformations:merge

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
transformations:merge [2021/07/18 22:42] craigttransformations:merge [2023/10/11 20:49] – [Remarks] craigt
Line 41: Line 41:
 For an inner join use the [[transformations:keepremovematching|Keep/remove matching]] action before merging to keep only the overlapping subset of values in the matching columns. For an inner join use the [[transformations:keepremovematching|Keep/remove matching]] action before merging to keep only the overlapping subset of values in the matching columns.
  
-The resulting table after Merge can't have more than 134,217,728 rows. 
  
 \\  \\ 
Line 47: Line 46:
  
  
-**Objective:** Merge the "Outflow" column of Table 2 into Table 1 based on matching values in the "Rivers" columns in both tables.\\+**Example:** Merge the "Outflow" column of Table 2 into Table 1 based on matching values in the "Rivers" columns in both tables.\\
  
 **Table 1:** The longest rivers in the world\\ **Table 1:** The longest rivers in the world\\
transformations/merge.txt · Last modified: 2024/04/11 23:55 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki