Category: Transform / Advanced

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 such cases, one row for each match will be inserted into the resulting table.

Interval merge can be used to to categorize or "bucket" values in a dataset that fall within a given range or scale, such as survey responses (1-3 = "bad", 4-6 = "neutral", 7-10 = "good"), temperature ranges, size scales, etc.

This action is a good substitute for a Lookup action that uses multiple lookup values with similar return values (e.g., 1="good", 2="good", 3="neutral", 4="bad", 5="bad).

The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window.

To create a lookup set that doesn't contain any "gaps" be sure to set the "less than" value one higher than the last value you want included in the range, and start the following pairing with that same value.

Objective: Find what it feels like in Toronto during the year.

Table 1: Temperature in Toronto (Celsius)

Table 2: Boundaries

Action parameters:

Table to merge is "Table 2"
Values in column (Table 1) is "Temp High (C)"
Are greater than or equal to "Lower" (in Table 2)
And less than "Upper" (in Table 2)

Result:

• Merge another table
• Community: Assign value from conditions based on a table (with downloadable example)
• Community: Example of using Interval Merge (with downloadable example)
• Community: Rules on 2 or more tables (with downloadable example)