AGE BAND lookup

[pradeep_nov18]

Hi All,

I have Requirement to reterive the id based on the range of value,Please help to resolve this.

Eg:

Table1:

Date1 Date2 AGE_Diff
20-01-2010 20-10-2010 9

Table2:
id MIN_VALUE MAX_VALUE
1 1 5
2 6 10
3 11 100


How to loookup Table1.AGE_DIFF to Table2.MIN_VALUE,MAX_VALUE(based on the range) i have to reterive the id 2 result for the above example.

Noted :Table1.AGE_DIFF is the driven.

Thanks for posting idea and solution in advance

[kadale.nilesh]

Range lookup is support in datastage 8x. U can directly check the value in a particular range.

[pradeep_nov18]

Range lookup is support in datastage 8x. U can directly check the value in a particular range.

Can you elaborate how can i do that,If any Condition let me know based on my example.

Thanks for help in Advance.

[ray.wurlod]

U can directly check the value in a particular range.

Indeed, anyone can, not just U (one of our posters).

The descriptions in the manual are quite clear. Show us what you have attempted.

[pradeep_nov18]

U can directly check the value in a particular range.

Indeed, anyone can, not just U (one of our posters).

The descriptions in the manual are quite clear. Show us what you have attempted.

Hi Ray,

I have drived the Table1 has my primary and while i perform look up with Table2(which is reference),I can see only one value that is "AGE" derived for MIN value, Max value,hence unable to retrieve exact band id.So i need some guidelines to incorporate the logic.

Thanks ,

[ArndW]

In your lookup stage in the bottom left box, specify "Key Type" as "Range" in order to do a range lookup.