Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  • Range joins apply only keys whose data types can be compared. 
    • For example, for joins involving keys of Binary data type, you can use Equal to or Not equal to joins.


      Tip: Range joins cannot be applied to Datetime data type values directly. However, if you convert the values to numeric Unix time values, you should be able to specify a range join. For more information, see UNIXTIME Function.

  • Any range comparison that includes one or more string columns as keys uses the string comparison greater/less than, not the numerical comparison.


  1. In the Search panel, enter join datasets in the search box. 
  2. Select the dataset with which to join the current one. Then, click Accept.
  3. In the Join window, select the join type. 
  4. In the Join Keys area, click the Pencil icon.
  5. Specify the fields in the current dataset and the joined-in dataset.
  6. From the Condition drop-down, select the range operator to use: 
    Image RemovedImage Added

    D caption
    Select range operator

  7. Specify other properties for the matching keys.

  8. Click Save and Continue.

  9. Specify other elements of the join. When finished, click Add to Recipe.