RANGE join, RANGE lookup and RANGE map
Currently in the ETL TableJoin Transform we only have the possiblity to define a join on an exact match of key fields in the right and left data source.
It would be great to be able to define a matching range (intervall) for the right data source.
In SQL this would be:
SELECT * FROM leftSource JOIN rightSource
ON (leftSource.joinField >= rightSource.range_start)
AND (leftSource.joinField <= rightSource.range_stop)
column "joinField": 250
column "range_start": 200
column "range_stop": 300
This would then give a matching record.
Same request is applicable for
Map-FieldTransform and Lookup-FieldTransform!
Done for Join and Lookup (function LookupInterval) in 7.0 SR1.
For Map planned #32965
Jens Consör commented
Actually it was already announced to become implemented in 2012:
(statement no. 5)