Talend community forum / inner join in tMap

YuKiiAi · 2008-07-16 12:23:14

Tags: [delimited file, development, java, tmap, tos2.4.0]

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

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

Uploaded Images

Last edited by shong (2008-07-17 08:32:44)

YuKiiAi · 2008-07-17 09:37:33

Thanks Shong,

It's work very well

Regards,
Yu

Last edited by YuKiiAi (2008-07-17 09:42:50)

Announcement

Unanswered posts

#1 2008-07-16 12:23:14

inner join in tMap

#2 2008-07-17 07:29:40

Re: inner join in tMap

Code:

#3 2008-07-17 09:37:33

Re: inner join in tMap

Board footer