User Tools

Site Tools


transformations:intervalmerge

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:intervalmerge [2018/08/15 09:45] dmitrytransformations: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:
 |     25|     99|Hot   | |     25|     99|Hot   |
  
-Table 2: Temperature in Toronto+Table 2: Temperature in Toronto (Celsius)
 ^Month ^High, C^ ^Month ^High, C^
 |Jan |   0| |Jan |   0|
Line 48: Line 48:
  
  
 +** See also **
 +  * [[transformations:merge|Merge another table]]
 +  * [[https://community.easymorph.com/t/assign-value-from-conditions-based-on-a-table/2292|Another example #1]]
 +  * [[https://community.easymorph.com/t/example-of-using-interval-merge/1851|Another example #2]]
 +  * [[https://community.easymorph.com/t/rules-on-2-or-more-tables/952|Another example #3]]
transformations/intervalmerge.txt · Last modified: 2021/07/19 02:24 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki