User Tools

Site Tools


transformations:intervalmerge

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revisionBoth sides next revision
transformations:intervalmerge [2018/08/15 09:15] – created dmitrytransformations:intervalmerge [2020/12/02 15:31] dmitry
Line 2: Line 2:
  
 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, in this case one row for each match will be inserted into the resulting table.
  
 **Example** **Example**
Line 11: 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 46: 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