You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » inner join in tMap
Post a reply
Topic review (newest first)
- YuKiiAi
- 2008-07-17 09:37:33
Thanks Shong,
It's work very well
Regards,
Yu
- shong
- 2008-07-17 07:29:40
Hello
Here comes a Java scenario,
vacation file:
1000001|01072008
1000002|02072008
people file:
11111111|00001
11111112|00002
result:
Code:
Starting job delimited at 13:29 17/07/2008. .--------+--------. | tLogRow_1 | |=-------+-------=| |p_id |date | |=-------+-------=| |11111111|01072008| |11111112|02072008| '--------+--------' Job delimited ended at 13:29 17/07/2008. [exit code=0]
Best regards
shong
- YuKiiAi
- 2008-07-16 12:23:14
I want to use inner join in tMap
I have 2 text files which vacation and people as input file
Output is report file type is csv
Example data
This is data
vacation people
--------------------- -------------------------
id | date p_id | empid
--------------------- -------------------------
1000001 | 01072008 11111111 | 00001
1000002 | 02072008 11111112 | 00002
Output
report
---------------------------
p_id | date
---------------------------
11111111 | 01072008
11111112 | 02072008
vacation.id is link to people.empid
I want to replace id to p_id
vacation is main and people is lookup
how to join this?
Thank you for answer
Regards,
Yu