Table, Tree (etc) Joins should be able to be cached in memory or at disc in the same way caching of extracts is possible4 votes
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!
Thanks :)3 votes
Done for Join and Lookup (function LookupInterval) in 7.0 SR1.
For Map planned #32965
- Don't see your idea?