Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

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

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

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.

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.

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

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

cinar
2011-11-14 15:33:54

hi Or3l,

I posted TMap View..

Or3l
2011-11-14 15:23:20

Can you post your tmap view?

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:14:56

Hi,
Did you try with a tMap?

cinar
2011-11-14 15:05:15

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

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 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.

Board footer

Powered by FluxBB