Differences

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

--- transformations:append [2020/12/04 08:00] – dmitry
+++ transformations:append [2021/07/19 02:32] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== Append table =====
+{{ transformations:AppendTableAction.png}}
+====== APPEND ANOTHER TABLE ======
+Category: Transform / Basic\\
-Appends another table. The action can operate in 2 modes:
+\\
+=====Description=====
+This action appends another table to the current dataset.  This action can operate in 2 modes:\\
+\\
+====Append rows====
+ The other table (dataset) is appended as new rows at the bottom of the current table. Columns with the same name in both tables appear as one column in the result table. Columns in the appended table that don't exist in the main table are appended on the right.
-**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 of the current dataset. Columns from the appended table with the same name as in the main table are automatically renamed. The length of the resulting table is the longest length of the two tables.\\
-This mode has the useful feature of preserving the order of columns of the main dataset to which the other dataset is appended.
+\\
+=====Use cases (Append rows)=====
+  * Concatenation of similar datasets.
+  * Incremental loading.
-**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.
+To append multiple datasets, apply the "Append" action multiple times.
+\\
+=====Action settings=====
+^Setting^Description^
+|Table to append|Select the dataset to append to the current one.|
+|Mode|Options:  //Append rows// at the bottom (columns with the same name are concatenated into one column), and,\\ //Append columns// to the right (columns with the same names are automatically renamed)|
-EXAMPLE
+Regardless of the mode, a dotted line will connect this action to the appended dataset in the application window.
+\\
+=====Examples=====
+**Example:** Append Table 2 to Table 1 as additional columns.
 **Table 1:** The longest rivers in the world
-^  River  ^  Length (km)  ^  Continent  ^
+^River  ^Length (km)  ^Continent  ^
-| Nile  |  6650  |  Africa  |
+| Nile  |  6650|Africa  |
-| Amazon  |  6400  |  South America  |
+| Amazon  |  6400|South America  |
-| Yangtze  |  6300  |  Asia  |
+| Yangtze  |  6300|Asia  |
-| Mississippi  |  6275  |  North America  |
+| Mississippi  |  6275|North America  |
 **Table 2:** The outflow
-^  River  ^  Outflow  ^
+^River  ^Outflow  ^
-| Nile  |  Mediterranean  |
+| Nile  |Mediterranean  |
-| Amazon  |  Atlantic Ocean  |
+| Amazon  |Atlantic Ocean  |
-| Yangtze  |  East China Sea  |
+| Yangtze  |East China Sea  |
-| Mississippi  |  Gulf of Mexico  |
+| Mississippi  |Gulf of Mexico  |
+\\
+**Action parameters:**
-**Objective:** Append Table 2 to Table 1
+>  Append columns to the right
+\\
-**Result:**
+**Result table:**
-^  River  ^  Length (km)  ^  Continent  ^  Outflow  ^
+^River  ^Length (km)  ^Continent  ^Outflow  ^
-| Nile  |  6650  |  Africa  |
+| Nile  |  6650|Africa  |
-| Amazon  |  6400  |  South America  |
+| Amazon  |  6400|South America  |
-| Yangtze  |  6300  |  Asia  |
+| Yangtze  |  6300|Asia  |
-| Mississippi  |  6275  |  North America  |
+| Mississippi  |  6275|North America  |
-| Nile  |    |    |  Mediterranean  |
+| Nile  |    |    |Mediterranean  |
-| Amazon  |    |    |  Atlantic Ocean  |
+| Amazon  |    |    |Atlantic Ocean  |
-| Yangtze  |    |    |  East China Sea  |
+| Yangtze  |    |    |East China Sea  |
-| Mississippi  |    |    |  Gulf of Mexico  |
+| Mississippi  |    |    |Gulf of Mexico  |
-=== More examples ===
+\\
-  * [[https://community.easymorph.com/t/excel-import-date-headings-as-number/2297|Example #1]]
+====Community examples====
-  * [[https://community.easymorph.com/t/product-of-rows-in-a-column/1854/2|Example #2]]
+  * [[https://community.easymorph.com/t//675/5|Compare two Excel sheets with EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/xQLWtAogCqcMrglyfXLKmrAF7aR.morph|Project]]; Module: //Main//; Group: //Compare column names//; Table: //Compare column names//; Action position: //2//)
-  * [[https://community.easymorph.com/t/how-to-parse-edi-file-e-g-x12-transaction-set-837/2267|Example #3]]
+  * [[https://community.easymorph.com/t//1854/2|Product of Rows in a Column]] ([[https://community.easymorph.com/uploads/short-url/8o7F1FHzlEr0hUV2BgCLFNEMKqk.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Result//; Action position: //2//)
+  * [[https://community.easymorph.com/t//1926/3|Sort column in an export alphabetically (tab)]] ([[https://community.easymorph.com/uploads/short-url/b1cFUp2TMl0yEassYLlT4oO3hxp.morph|Project]]; Module: //Main//; Group: //Enum/pivot/append//; Table: //Result//; Action position: //2//)
+  * [[https://community.easymorph.com/t//2267/1|How to parse EDI file (e.g. X12 transaction set 837)]] ([[https://community.easymorph.com/uploads/short-url/6tzpyfamtKPeOq37FyUjBxKud4F.morph|Project]]; Module: //Build line//; Group: //Append result//; Table: //Result//;\\ Action position: //5//)
+  * [[https://community.easymorph.com/t//2297/2|Excel: Import Date Headings as number]] ([[https://community.easymorph.com/uploads/short-url/ppgiXxeiQbK0O3owwca3pxAsOyH.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //New header//; Action position: //6//)
-=== See also ===
+\\
+=====See also=====
   * [[transformations:merge|Merge another table]]
   * [[transformations:peek|Peek]]