Hello everyone,
I have a question on range lookup in lookup stage. I have got a requirement to do a range lookup for one column (like value between '291' and '29209'). I used range expression on the source link column. It is not giving the correct output.
Here is the scenario. Source value is '291K0' which is between '291' and '29209' as per character comparison. Is it allows only integer and date columns for range comparison?
Please advice. Thanks in advance.
character range lookup in lookupstage
Moderators: chulett, rschirm, roy
character range lookup in lookupstage
Thanks,
Sai
Sai
Are the columns all defined as varchar() and without leading or trailing blanks? I can't check right now, but that between should work.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I just created a test job with exactly the values you specified for the range lookup and it works as it should. I used varchar() columns (not char()) and it works like a charm.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I had a similar issue with 8.7
where range lookup faild to work
I had a single column with ID + a ranged timestamp column
that didn't work as expected.
Due to short time to resolve I ended up checking the TimestampToDecimal() values in a transformer.
The down side is that is made multiple of the rows since so many were joined by the ID column, but it worked.
IHTH (I Hope This Helps),
where range lookup faild to work
I had a single column with ID + a ranged timestamp column
that didn't work as expected.
Due to short time to resolve I ended up checking the TimestampToDecimal() values in a transformer.
The down side is that is made multiple of the rows since so many were joined by the ID column, but it worked.
IHTH (I Hope This Helps),
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
I'm using Version 11. I don't think that this behavior has changed though and think that there is some other problem involved here. I made a simple test job that I think you should try as well to make a small example which, if it doesn't work, you can send to your service provider.
A row generator for your lookup value, with a single row and just that one value, '291K0'. Another row generator which make column "from" and "to" with values '291' and '29209' respectively. Then a lookup for the range and output to a PEEK stage. All datatypes are "varchar".
A row generator for your lookup value, with a single row and just that one value, '291K0'. Another row generator which make column "from" and "to" with values '291' and '29209' respectively. Then a lookup for the range and output to a PEEK stage. All datatypes are "varchar".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
good to hear in V.11 it works
I also had to get the records not in the range lookup for another flow
so processed so many records twice
So There is the "wrok around" that I implemented
I also had to get the records not in the range lookup for another flow
so processed so many records twice
So There is the "wrok around" that I implemented
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org