Talend community forum / [resolved] TJOIN - Inner Join Problem

cinar · 2011-11-14 14:50:01

Hello Friends,

I am using Tjoin component to make inner join between 2 tables. But When it runs, Tjoin component protects the datas which are coming from the main table and joins with the lookup table's key attribute's last row.

For Example,

A Table B Table
A1 Column B1 Column, B2 Column
---------- -------------- ------------
1 1 01
2 1 02
3 2 01
2 03
3 04
3 05

The result which Tjoin generates is the below:

x y z
1 1 02
2 2 03
3 3 05

But I want it to make inner join like the following:
x y z
1 1 01
1 1 02
2 2 01
2 2 03
3 3 04
3 3 05

How can I achive to do this and by which component?
and My Job's screenshot has been attached so it can provide deeper informaation about the problem. Thanks in advance.

Uploaded Images

Last edited by cinar (2011-11-14 15:35:08)

brandon_stubbs93 · 2011-11-14 14:54:36

Hi Cinar

is it not possible to do this straight in your query?

Code:

SELECT a.A1 FROM TableA a
INNER JOIN TABLEB b on a.A1 = b.B1
GROUP BY b.B1, b.B2

Regards
Brandon

cinar · 2011-11-14 15:05:15

No, I must do this with components.. Thanks for the reply.

Or3l · 2011-11-14 15:14:56

Hi,
Did you try with a tMap?

cinar · 2011-11-14 15:20:00

Hi,

Yes, I tried the Tmap as well, But I got the same result.

Or3l · 2011-11-14 15:23:20

Can you post your tmap view?

cinar · 2011-11-14 15:33:54

hi Or3l,

I posted TMap View..

brandon_stubbs93 · 2011-11-14 15:42:48

cinar,

In your tmap have you changed the match model to join on all matches?

Regards
Brandon

Uploaded Images

Last edited by brandon_stubbs93 (2011-11-14 15:46:39)

Or3l · 2011-11-14 15:44:16

Sorry I've just seen one picture at first. On the row8 table in your tmap view, click on "tool" item, (the one on the left), then in the join model choose inner join

cinar · 2011-11-14 15:48:27

Hi brandon_stubbs93 & Or3l,

No, I didnt change the join model As I didnt know whether such a thing exists or not:) I will try this and write the result back here.. Thanks for your helps.

cinar · 2011-11-14 15:56:01

Wowww, That worked!!! I'm so happy really like a child. I have tried to fix this problem whole day long. Thank you guys:)
ismail.cinar@obase.com You guys can write me whenever you want...

Thanks again.

simGill · 2011-11-23 19:07:10

I have question to Bradon_Stubs93 .
I have two csvs and have more than 500,000 records.I have to do inner join if I do all matches Its not able to write csv because it creates too many duplicates in it ...

Is any body can help me how to get all records and no duplicate ...I really need this done Otherwise I'll be in trouble.Thanks for you help

brandon_stubbs93 · 2011-11-24 14:31:39

Hi simGill

Surely the match model for that situation would be Unique match and the Join Model Inner join in your tMap?

Regards,
Brandon

Announcement

Unanswered posts

#1 2011-11-14 14:50:01

[resolved] TJOIN - Inner Join Problem

#2 2011-11-14 14:54:36

Re: [resolved] TJOIN - Inner Join Problem

Code:

#3 2011-11-14 15:05:15

Re: [resolved] TJOIN - Inner Join Problem

#4 2011-11-14 15:14:56

Re: [resolved] TJOIN - Inner Join Problem

#5 2011-11-14 15:20:00

Re: [resolved] TJOIN - Inner Join Problem

#6 2011-11-14 15:23:20

Re: [resolved] TJOIN - Inner Join Problem

#7 2011-11-14 15:33:54

Re: [resolved] TJOIN - Inner Join Problem

#8 2011-11-14 15:42:48

Re: [resolved] TJOIN - Inner Join Problem

#9 2011-11-14 15:44:16

Re: [resolved] TJOIN - Inner Join Problem

#10 2011-11-14 15:48:27

Re: [resolved] TJOIN - Inner Join Problem

#11 2011-11-14 15:56:01

Re: [resolved] TJOIN - Inner Join Problem

#12 2011-11-23 19:07:10

Re: [resolved] TJOIN - Inner Join Problem

#13 2011-11-24 14:31:39

Re: [resolved] TJOIN - Inner Join Problem

Board footer