Has file lookup using less than or rather than
Posted: Tue Feb 06, 2007 3:12 am
I have a hash file containing three key colums, one of the columns is a number column containing 100, 200, 500 etc. (sorted)
The main input column mapped to the hash file contains numbers between 0 and 1000.
I want to be able to map to the correct column in the hash file using less than or grather than.
Let's say input value is 124.
On the mapping column, I change the input value to a string like this:
>124. The correct row found should be the row with 200 in its key number field.
Because data is sorted, the transformer will find the first row with a key value > 124... Is this possible ?
If I use multiple row lookup using a UniVerse stage, can I select one row from several rows by using less than / grater than or other functions ?
Chris.
The main input column mapped to the hash file contains numbers between 0 and 1000.
I want to be able to map to the correct column in the hash file using less than or grather than.
Let's say input value is 124.
On the mapping column, I change the input value to a string like this:
>124. The correct row found should be the row with 200 in its key number field.
Because data is sorted, the transformer will find the first row with a key value > 124... Is this possible ?
If I use multiple row lookup using a UniVerse stage, can I select one row from several rows by using less than / grater than or other functions ?
Chris.