Well, I know that is not possible to make a range lookup with an hashed file directly.
My situation is this.
I've a stream from an oledb stage and an hashed file as reference linked to the same transformer.
Hashed file is previously filled in with data obtained from another table. its structure is this:
id | fromValue | toValue | description
1 | -999 | -1 | undefined
2 | 0 | 60 | short term
3 | 61 | 90 | medium term
4 | 91 | 999 | long term
the maximum number of rows that this hashed file will reach is I think 10. (no intersections possible among rows as regard "from" and "to" values)
The stream have several fields, the one I'm interested in now is a value field i.e.:
value field1 field2 ...
64
99
104
..
My goal is to join the two tables in order to associate the id from the hashed file to each value field of the stream
I read in this forum that what I need is possible in two different ways:
- by using an Universe stage and performing the join in the transformer
- by preloading the data retrived from the hashed file in a before-stage routine and by using a transform function in the transformer key expression (is it right?)
I'd like to improve this second way (I read that it's better than the other one) but I haven't understood how to make the preload of the hashed file data and what my function must contain.. sincerely i'm not even sure if I've well understood the way to proceed
![Confused :?](./images/smilies/icon_confused.gif)
I looked for further information in the forum but I haven't found nothing of helpful for me.
thanks a lot for every help