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 [2021/04/10 22:00] – craigt | transformations:intervalmerge [2021/04/10 22:59] – craigt | ||
---|---|---|---|
Line 24: | Line 24: | ||
\\ | \\ | ||
=====Remarks===== | =====Remarks===== | ||
- | To create a lookup set that doesn' | + | To create a lookup set that doesn' |
^Low ^High ^Label | ^Low ^High ^Label | ||
Line 30: | Line 30: | ||
| 4| 8| Range is 4 to __7__ (don't start with " | | 4| 8| Range is 4 to __7__ (don't start with " | ||
| 8| 11| Range is 8 to __10__. (range end is " | | 8| 11| Range is 8 to __10__. (range end is " | ||
+ | \\ | ||
+ | A lookup pair (low, high) cannot have a " | ||
+ | \\ | ||
+ | //Interval merge// can also use text-based lookup ranges and values (see Example 2, below).\\ | ||
\\ | \\ | ||
=====Examples===== | =====Examples===== | ||
- | **Objective:** Find what it feels like in Toronto during the year.\\ | + | **Example 1:** Find what it feels like in Toronto during the year.\\ |
**Table 1:** Temperature in Toronto (Celsius) | **Table 1:** Temperature in Toronto (Celsius) | ||
Line 77: | Line 81: | ||
|Nov | | |Nov | | ||
|Dec | | |Dec | | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | **Example 2:** Use a letter-based merge to assign Names to letter ranges. | ||
+ | |||
+ | **Table 1:** Names | ||
+ | ^Name ^ | ||
+ | |Mary | | ||
+ | |Sally | ||
+ | |Bob | | ||
+ | |Max | | ||
+ | |Bruce | ||
+ | |Tammy | ||
+ | |Chris | ||
+ | |Frank | ||
+ | |Zeek | | ||
+ | |||
+ | **Table 2:** Lookup ranges | ||
+ | ^Low ^High ^Label | ||
+ | |A |F |Range A-E | | ||
+ | |F |L |Range F-K | | ||
+ | |L |S |Range L-R | | ||
+ | |S |Z |Range S-Y | | ||
+ | |Z |Zz |Range Z | | ||
+ | The high value of " | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Table to merge is "Table 2" | ||
+ | > Values in column " | ||
+ | > Are greater or equal to " | ||
+ | > And less than " | ||
+ | > Columns to merge is " | ||
+ | \\ | ||
+ | **Result:** | ||
+ | ^Name ^Label | ||
+ | |Mary |Range L-R | | ||
+ | |Sally | ||
+ | |Bob |Range A-E | | ||
+ | |Max |Range L-R | | ||
+ | |Bruce | ||
+ | |Tammy | ||
+ | |Chris | ||
+ | |Frank | ||
+ | |Zeek |Range Z | | ||
+ | |||
\\ | \\ | ||
=====See also===== | =====See also===== | ||
+ | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
* [[https:// | * [[https:// | ||
* [[https:// | * [[https:// | ||
* [[https:// | * [[https:// |
transformations/intervalmerge.txt · Last modified: 2021/07/19 02:24 by craigt