transformations:crossmerge
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:crossmerge [2018/08/23 07:36] – dmitry | transformations:crossmerge [2021/07/15 12:04] – [Community 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===== | ||
+ | |||
+ | **Objective: | ||
**Table: Years** | **Table: Years** | ||
- | |||
^ Year ^ | ^ Year ^ | ||
| 2016 | | | 2016 | | ||
| 2017 | | | 2017 | | ||
- | |||
**Table: Quarters** | **Table: Quarters** | ||
- | |||
^ Quarter | ^ Quarter | ||
| Q1 | | | Q1 | | ||
Line 23: | Line 42: | ||
| Q3 | | | Q3 | | ||
| Q4 | | | Q4 | | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Merge table: | ||
+ | > All columns | ||
+ | (The resulting dataset will contain 8 rows. Table " | ||
- | **Objective: | + | \\ |
- | + | ||
- | **Transformation: | + | |
- | Table " | + | |
**Result:** | **Result:** | ||
- | |||
^ Year ^ Quarter | ^ Year ^ Quarter | ||
| 2016 | Q1 | | | 2016 | Q1 | | ||
Line 42: | Line 61: | ||
| 2017 | Q4 | | | 2017 | Q4 | | ||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
- | [[https:// | + | \\ |
+ | =====See also===== | ||
+ | * [[transformations:intervalmerge|Interval merge]] | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/crossmerge.txt · Last modified: 2021/07/19 02:28 by craigt