transformations:crossmerge
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:crossmerge [2018/08/23 07:37] – 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: | + | \\ |
- | + | **Result | |
- | **Transformation: | + | |
- | Table " | + | |
- | + | ||
- | **Result:** | + | |
^ Year ^ Quarter | ^ Year ^ Quarter | ||
- | | 2016 | Q1 | | + | | 2016|Q1 |
- | | 2016 | Q2 | | + | | 2016|Q2 |
- | | 2016 | Q3 | | + | | 2016|Q3 |
- | | 2016 | Q4 | | + | | 2016|Q4 |
- | | 2017 | Q1 | | + | | 2017|Q1 |
- | | 2017 | Q2 | | + | | 2017|Q2 |
- | | 2017 | Q3 | | + | | 2017|Q3 |
- | | 2017 | Q4 | | + | | 2017|Q4 |
- | ===See also=== | + | \\ |
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
- | * [[transformations: | + | * [[transformations: |
- | * [[https:// | + |
transformations/crossmerge.1535024238.txt.gz · Last modified: 2018/08/23 07:37 by dmitry