transformations:intervalmerge
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
transformations:intervalmerge [2020/12/02 15:32] – dmitry | transformations:intervalmerge [2021/04/10 22:00] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Interval merge ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced \\ | ||
+ | \\ | ||
+ | =====Description===== | ||
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 such cases, one row for each match will be inserted into the resulting table.\\ |
- | **Example** | + | \\ |
+ | =====Use cases===== | ||
+ | //Interval merge// can be used to to categorize or " | ||
- | Table 1: Boundaries | + | This action is a good substitute for a [[transformations:lookup|Lookup]] action that uses multiple lookup values with similar return values (e.g., 1=" |
- | ^ Lower ^ Upper ^ Feels ^ | + | |
- | | 0| | + | |
- | | | + | |
- | | | + | |
- | Table 2: Temperature in Toronto (Celsius) | + | \\ |
- | ^Month ^High, C^ | + | =====Action settings===== |
+ | ^Setting^Description^ | ||
+ | |Merge table|Select the table to merge with the current dataset.| | ||
+ | |Columns|Select whether to merge all columns in the second dataset, or just selected columns. | ||
+ | The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | To create a lookup set that doesn' | ||
+ | |||
+ | ^Low ^High ^Label | ||
+ | | 0| 4| Range is 0 to __3__| | ||
+ | | 4| 8| Range is 4 to __7__ (don't start with " | ||
+ | | 8| 11| Range is 8 to __10__. (range end is " | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Table 1:** Temperature in Toronto (Celsius) | ||
+ | ^Month ^Temp High (C)^ | ||
|Jan | | |Jan | | ||
|Feb | | |Feb | | ||
Line 28: | Line 51: | ||
|Dec | | |Dec | | ||
- | Goal: find what it feels like in Toronto during a year. | + | **Table 2:** Boundaries |
- | + | ^ Lower ^ Upper ^ Feels ^ | |
- | Solution: merge using the "Interval merge" | + | | 0| |
- | + | | | |
- | Table: | + | | |
+ | \\ | ||
+ | **Action parameters:** | ||
+ | > Table to merge is "Table 2" | ||
+ | > Values | ||
+ | > Are greater than or equal to "Lower" (in Table 2) | ||
+ | > And less than "Upper" (in Table 2) | ||
+ | \\ | ||
+ | **Result:** | ||
^Month ^High, | ^Month ^High, | ||
|Jan | | |Jan | | ||
Line 47: | Line 78: | ||
|Dec | | |Dec | | ||
- | + | \\ | |
- | ** See also ** | + | =====See also===== |
* [[transformations: | * [[transformations: | ||
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
transformations/intervalmerge.txt · Last modified: 2021/07/19 02:24 by craigt