hOW CAN i IMPLEMENT A SQL 'BETWEEN' IN AN TRANSFORMATION

[LANDO]

Hi All,

I'm have 2 tables A: have person age
B: A certain id for age range.
meaning : Person with age value of 24 in table A
will mean in table B id : 3 start_age: 20, end_age: 25

so when I join these table in SQL and ask for the id the sql statement will look like this:
select b.id
from a,b
where a.age between b.start_age and b.end_age

how can implement the above in a transformation, I know I can try and use custom SQL, but is there a way to do it via the transformation it self

[ray.wurlod]

Create a transform function (Routine). Best is to use searchable structures - dynamic arrays or Btree files - that are cached in memory (declared as COMMON).