topic Re: [resolved] Lookup non fonctionnelle in Talend Studio

[resolved] Lookup non fonctionnelle

Anonymous — Mon, 11 Nov 2013 15:54:26 GMT

bonjour,
j'en ai deux source différentes (un main et un lookup) que je voulais joindre via tMap.
Je constate que la jointure entre les deux champs string ne fonctionne pas pourtant les deux champs sont les memes.
PS: les sources sont des tDBInput (tables paradox)

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 02:31:31 GMT

Hi,
This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!
Best regards
Sabrina

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 07:29:47 GMT

Hi,
Excuse my ignorance, here is the traduction:
I have two data source (tDBInput) one is the main the other is a lookup, i want to join them with a tMap via string fields . The problem is that i have no match correspondances although the fields are same (same contained and lenght)

Ps: the data source are from different paradox format table, the first is paradox7(Driver do Microsoft paradox *.db) the second is paradox9(INTERSOLV 3.11 32 bit paradox file)

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 07:46:08 GMT

Hi,

The problem is that i have no match correspondances although the fields are same (same contained and lenght)

.
Do you mean you cannot join them in tmap? Did you check the component reference document TalendHelpCenter:tMap? Could you give us the screenshots of your two input source and tmap editor so that we can address your issue more quickly.
Best regards
Sabrina

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 08:22:53 GMT

You see that it is a simple Job of test
ReferenceArticle and BK_RefArticle are same.
Source1 and Source2 are from different ODBC driver (I think that it's a preoblem of caratere conversion)
Do you have any suggestion ?

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 08:28:23 GMT

here is the TMap

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 08:46:01 GMT

Hi,
How did you set the "join model" and "Match Model" in tmap? what the input source look like? Elaborating your case with an example with input and expected output values will be appreciated.
You'd better use forum "Image Upload" box to upload screen captures (20 images per post, each image must be less then 1024x768 pixels and 200 KB), which would be easier for you and more convenient for other users.
Best regards
Sabrina

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 08:56:12 GMT

Join model : Left outer join
Match model : Unique correspondence
DesignationArticle, codeFamilleArticle and FamilleArticle are extra column from the Lookup, I can delete theme no problem.

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 09:55:56 GMT

Just onther question:
Do you know how to apply talend function on a lookup field (on the tMap) ?
because : TalendString.talendTrim(BK_RefArticle,' ',0) could resolve the problem, but i can't put it on the tMap

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 10:19:54 GMT

Hi,
Set the talend method in tmap expression

TalendString.talendTrim(row.ColumnName,' ',0)

.
As a matter of fact, there is also an option for "Trim all the String/Char columns" in tDBinput component Advanced Settings.
See my screenshots.
Best regards
Sabrina

Re: [resolved] Lookup non fonctionnelle

Anonymous — Tue, 12 Nov 2013 13:30:31 GMT

Thank you so much xdshi, your second option save my life, this avois me to put a TMap after every tDBInput to trim blancs

Re: [resolved] Lookup non fonctionnelle

Anonymous — Wed, 13 Nov 2013 03:20:45 GMT

Hi,
Is the Lookup function working for you after Trimming? Feel free post your issue on forum.
Best regards
Sabrina

Re: [resolved] Lookup non fonctionnelle

Anonymous — Fri, 15 Nov 2013 13:24:03 GMT

Hi,
Yes lookup is working after I cheked the "Trim all the string/char column"
Thank you

Re: [resolved] Lookup non fonctionnelle

Anonymous — Mon, 18 Nov 2013 03:10:32 GMT

Hi,
It is great, thanks for your feedback.
Best regards
Sabrina