transformations:crossmerge
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:crossmerge [2018/07/21 11:40] – created dmitry | transformations:crossmerge [2021/07/19 02:28] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Cross merge ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced \\ | ||
- | This action creates a table with all possible combinations (i.e. Cartesian product) of rows in two table. | + | \\ |
+ | =====Description===== | ||
+ | This action creates a table with all possible combinations (i.e. Cartesian product) of rows in two tables.\\ | ||
- | It can be helpful in a number of cases: | + | \\ |
+ | =====Use cases===== | ||
+ | //Cross Merge// | ||
+ | * Generating | ||
+ | *Performing | ||
- | Note that EasyMorph can handle tables | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Merge table|Select the table to merge with the current dataset.| | ||
+ | |Columns|Select whether | ||
+ | The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window.\\ | ||
- | EXAMPLE | + | \\ |
+ | =====Remarks===== | ||
+ | This action can produce extremely large tables, so make sure that you’re not cross-merging large tables. To estimate the number of rows in the resulting table, multiply the number of rows in both source datasets.\\ | ||
+ | |||
+ | EasyMorph can handle tables with up to 536 million records only. \\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Example: | ||
**Table: Years** | **Table: Years** | ||
- | |||
^ Year ^ | ^ Year ^ | ||
- | | 2016 | | + | | 2016| |
- | | 2017 | | + | | 2017| |
**Table: Quarters** | **Table: Quarters** | ||
- | |||
^ Quarter | ^ Quarter | ||
- | | Q1 | | + | |Q1 | |
- | | Q2 | | + | |Q2 | |
- | | Q3 | | + | |Q3 | |
- | | Q4 | | + | |Q4 | |
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Merge table: | ||
+ | > All columns | ||
+ | (The resulting dataset will contain 8 rows. Table " | ||
- | **Objective:** Create a custom calendar with quarters in years 2016-2017. | + | \\ |
+ | **Result table:** | ||
+ | ^ Year ^ Quarter | ||
+ | | | ||
+ | | 2016|Q2 | ||
+ | | 2016|Q3 | ||
+ | | 2016|Q4 | ||
+ | | 2017|Q1 | ||
+ | | 2017|Q2 | ||
+ | | 2017|Q3 | ||
+ | | | ||
- | **Transformation:** Cross-merge. | + | \\ |
- | Table " | + | ====Community examples==== |
- | + | | |
- | **Result:** | + | * [[https:// |
- | + | | |
- | ^ Year ^ Quarter | + | |
- | | | + | |
- | | 2016 | + | |
- | | 2016 | Q3 | | + | |
- | | 2016 | Q4 | | + | |
- | | 2017 | Q1 | | + | |
- | | 2017 | Q2 | | + | |
- | | 2017 | Q3 | | + | |
- | | 2017 | Q4 | + | |
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/crossmerge.1532187633.txt.gz · Last modified: 2018/07/21 11:40 by dmitry