How to get tMap to join Between values?

[rlmagidson]

Hello all
Here's my scenario: I have one table that lists financial account ranges and descriptions (e.g. "Payroll" accounts range from 51110 to 51199, "Parts" accounts range from 61250 to 62250, etc.) and a second with account transactions (e.g. 1/5/2010 entry of $1,000 for account 51115, 2/1/2010 entry of $500 for account 62000, etc.). I need to assign the transactional data the appropriate payroll description. I'm basically building staging tables for operating statement analysis... someone else must have done this (or something similar).
How can I join based on ranges as opposed to discrete values? How do I specify this in the tMap editor?
Thanks in advance - I appreciate the help
- Russell

[_AnonymousUser]

Hello.
Thanks for the reply.


With usCity data :
====
TITLE
====
Denver
Springfield
Boise
Topeka
Denver
==
And houseData :
=========
CITY | HOUSE
=========
enver | 1
=========
I would like to have as result, with a "like" :
.-----------+-----.
| finalDataLog |
|=----------+----=|
|Title |House|
|=----------+----=|
|Denver |1 |
|Springfield|null |
|Boise |null |
|Topeka |null |
|Denver |1 |
'-----------+-----'
But what i got instead :
.------+-----.
|finalDataLog|
|=-----+----=|
|Title |House|
|=-----+----=|
|Denver|1 |
|Denver|1 |
'------+-----'.
What am i doing wrong ?
Please apology my crude english,
Regards,

[_AnonymousUser]

Hi.
As a workaround, I will store my usCity data into a sgbd then, do that inner join between my table and my houseData, then do a outer join in a tmap between my usCity data and my table.
It's a bit tricky but I think it's the easiest solution, if the tmap is really unable to make a Left outer join with a "like".
regards,
jeremy.

[Anonymous]

I want join put condition for fetching record between two table , this is hive where clause 
here i want only last 91 days record 
s and d are two table which will be join as cross join 
condition is s.invoicedt between date_sub(d.date1,91) and d.date1
how to implement in tamp?