transformations:intervalmerge
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:intervalmerge [2018/08/15 09:45] – dmitry | transformations:intervalmerge [2020/12/02 15:31] – dmitry | ||
---|---|---|---|
Line 3: | Line 3: | ||
This action merges two tables based on whether a value in one table falls into a range specified by two values in another table. | This action merges two tables based on whether a value in one table falls into a range specified by two values in another table. | ||
- | The lower boundary of a range is inclusive, the upper is exclusive. Ranges can overlap. | + | The lower boundary of a range is inclusive, the upper is exclusive. Ranges can overlap, in this case one row for each match will be inserted into the resulting table. |
**Example** | **Example** | ||
Line 13: | Line 13: | ||
| | | | ||
- | Table 2: Temperature in Toronto | + | Table 2: Temperature in Toronto |
^Month ^High, | ^Month ^High, | ||
|Jan | | |Jan | | ||
Line 48: | Line 48: | ||
+ | ** See also ** | ||
+ | * [[transformations: | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// |
transformations/intervalmerge.txt · Last modified: 2021/07/19 02:24 by craigt