Lookup based on a value range

[_AnonymousUser]

Hello, I'm new to Talend, and I was wondering how to perform a join from a value to a value range. For instance:
I have a source table with a column "amount" with the following values:
1
2
54
220
I have a lookup table defined with the following columns

ID high low
1 15 0
2 50 16
3 100 51
4 500 101

I wanted to perform a lookup using a tmap object, mapping amount to a specific id so the results should yield:
1
1
3
4
Is this possible?
Any help would be appreciated.
Thanks and regards,
-Frank

[_AnonymousUser]

My Apologies. Yes, the second value should be 5, not 2. I pasted the wrong text. This should result in:
5
5
5
4

[Anonymous]

ok I will try to do it, wait a moment please

[Anonymous]

I think the main difficulty doesn't come from your double file but from the fact that your rate interval isn't really an interval.
I'm not able to do it at this moment. I'm sorry