Differences

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

--- transformations:append [2014/10/25 17:05] – created dmitry
+++ transformations:append [2020/12/04 08:00] – dmitry
@@ Line 1: / Line 1: @@
 ===== Append table =====
-This transformation appends another table at the bottom of current table. Columns with the same name in both tables appear as one column in the result table.
+Appends another table. The action can operate in 2 modes:
+**Appends rows** - the other table (dataset) is appended as new rows at the bottom of current table. Columns with the same name in both tables appear as one column in the result table. Columns on the appended table that don't exist in the main table are appended on the right.
+This mode has the useful feature of preserving the order of columns of the main dataset to which the other dataset is appended.
+**Append columns** - the other table (dataset) is appended as new columns to the right. Columns from the appended table with the same name as in the main table are automatically renamed. The length of the resulting table has the length of the longest of the two table.
+EXAMPLE
+**Table 1:** The longest rivers in the world
+^  River  ^  Length (km)  ^  Continent  ^
+| Nile  |  6650  |  Africa  |
+| Amazon  |  6400  |  South America  |
+| Yangtze  |  6300  |  Asia  |
+| Mississippi  |  6275  |  North America  |
+**Table 2:** The outflow
+^  River  ^  Outflow  ^
+| Nile  |  Mediterranean  |
+| Amazon  |  Atlantic Ocean  |
+| Yangtze  |  East China Sea  |
+| Mississippi  |  Gulf of Mexico  |
+**Objective:** Append Table 2 to Table 1
+**Result:**
+^  River  ^  Length (km)  ^  Continent  ^  Outflow  ^
+| Nile  |  6650  |  Africa  |
+| Amazon  |  6400  |  South America  |
+| Yangtze  |  6300  |  Asia  |
+| Mississippi  |  6275  |  North America  |
+| Nile  |    |    |  Mediterranean  |
+| Amazon  |    |    |  Atlantic Ocean  |
+| Yangtze  |    |    |  East China Sea  |
+| Mississippi  |    |    |  Gulf of Mexico  |
+=== More examples ===
+  * [[https://community.easymorph.com/t/excel-import-date-headings-as-number/2297|Example #1]]
+  * [[https://community.easymorph.com/t/product-of-rows-in-a-column/1854/2|Example #2]]
+  * [[https://community.easymorph.com/t/how-to-parse-edi-file-e-g-x12-transaction-set-837/2267|Example #3]]
+=== See also ===
+  * [[transformations:merge|Merge another table]]
+  * [[transformations:peek|Peek]]