Differences

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

--- transformations:append [2015/04/17 23:31] – elenap
+++ 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
@@ Line 35: / Line 42: @@
 | 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|Blend in another table]]
+  * [[transformations:merge|Merge another table]]
+  * [[transformations:peek|Peek]]