In most join operations, the values in primary keys across two tables must match exactly for the related columns to be included in the join. In a range join, you can change the comparative operator for the keys from Equal to one of the following additional comparisons:
NOTE: A may need to enable this feature in your environment. See Workspace Admin Page.
Range joins allow you to include many more matching values and therefore rows in the join. Depending on the matches and the included columns, your resulting dataset can become very large. You should use this feature with some caution.
After range joins have been enabled, you can specify them as part of performing any join operation.
join datasetsin the search box.
From the Condition drop-down, select the range operator to use:
Select range operator
Specify other properties for the matching keys.
Click Save and Continue.
Specify other elements of the join. When finished, click Add to Recipe.
For more information, see Join Panel.