You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2006-09-28 16:16:23

cbelro
Member
3 posts

cbelro said:

Joint creation

Hello,

Is there a way to create a joint between two tables of the repository ?

I can't find how to do it.



Anyway, thx to the dev team for this new tool smile

Offline

#2 2006-09-28 16:39:59

nrousseau
Talend Team


nrousseau said:

Re: Joint creation

In fact, there's no "join" component yet.
It will be certainly available later.

There is still a way to make a "join" with the tMap, even if this may be a bit difficult to do it without the documentation yet.
The only thing is that the "reference" must have a limited amount of datas. I mean that you can't have for example 1gb of datas in the reference, as all references will be loaded in the memory if you use this way.

Offline

#3 2006-09-29 12:44:12

nferay
Member
62 posts

nferay said:

Re: Joint creation

I think that it is a very important functionality. without this functionality, I do not see how to use the repository. Indeed, It is very rare to make a process on a single table.

Last edited by nferay (2006-09-29 13:56:45)

Offline

#4 2006-10-01 19:14:38

fbonan
Guest

fbonan said:

Re: Joint creation

Hi!

Sure, I agree, "join" is a major functionality!
As Nicolas wrote, Talend has not yet a simple mono-join component.

But our tMap component can handle multiple (possibly complex) join at a time.
Here is how to do it (it's much more simple than it appears!):

First, Drag n' drop the following components :

- tFileInputDelimited
- tMap
- tFileOutputDelimited

Edit then load (or create) de schema for the tFileInputDelimited.
Then connect your tFileInputDelimited to a tMap.
Then, right-clicking on the tMap, create an new output and connect it to the tFileOutputDelimited.

Then add a new tFileInputDelimited (for example) and place it above the tMap component ; this data source will be taken for the lookup.

Create a connection beetween this new tFileInput and the tMap right clicking on the new tFileInputDelimited and selecting the Row item ; notice than this new link is in dash-point-style and as a "lookup"

Now open the tMap double-clicking on the component.

As you can see the tMap has now 2 tables on the left.
The first one is your main data source. The second one is your lookup  data source.

Now all you have to do is to create the joint beetween those tables.
For that, simply drag'n drop your id row of the first table on the id row of the second table.
As yous should see, a new link appears on the left (in yellow).

Now select some rows on the first and on the second table and drag'n drop them on the table on the right.

and......That's all ;-)


As a tips I can explain (on demand!) how you can transform the key to perform more complex lookup.
Full documentation will be available soon... (next week)!

Regards,
Fabrice

Note1: you can use any input/output component to connect to/from (eg. Delimited, XML, DB...).
Note2: the tMap accept One main data source, as many lookup source as you want and as many output as you want...

#5 2006-10-02 09:59:13

nferay
Member
62 posts

nferay said:

Re: Joint creation

Thank you for your help

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy