How can we improve Jedox Software?

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)

Example:

left source
-------------
column "joinField": 250

right source
---------------
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
Sign in Sign in with Jedox AG
Signed in as (Sign out)

We’ll send you updates on this idea

Jens Consör shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in Sign in with Jedox AG
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base