One Star

tFuzzyMatch : Can't add field from look up table inside output table

Hello
I am using this component to mark entries from on table that exist on another table.
Anyway, I would like to add one field from the second table (lookup table) inside the output table (first one with tFuzzy infos)
Problem is, inside the component I can see the two tables, but can't embed the desired field.
Thanks for your feedback and have a nice day.
7 REPLIES
Four Stars

Re: tFuzzyMatch : Can't add field from look up table inside output table

Can you pl put a screenshot? of the job and component?
What is the problem that you are facing?
Vaibhav
One Star

Re: tFuzzyMatch : Can't add field from look up table inside output table

Hi and sorry for the late answer.
Two pics are attached :
One with the whole job and one the tFuzzy schema edition window.
About the job.
Left table is a list of recipient of a mailing, all identified with a unique customer code.
Top table (lookup) is a table of the unique customer codes that has been scanned after the letter came back.
What I try to to do is end up with the recipient list, but with a new field leting me know the mail came back (Here that will be the value of each match found with tFuzzy) and this work.
What i would like to do is another field on the outputed table.
This field is inside the lookup table.
Thanks for your feedback.
One Star

Re: tFuzzyMatch : Can't add field from look up table inside output table

Sorry, I forgot one picture...
Four Stars

Re: tFuzzyMatch : Can't add field from look up table inside output table

Hi,
Fuzzy match objective is - Compares a column from the main flow with a reference column from the lookup flow and outputs the main flow data
https://help.talend.com/search/all?query=tFuzzyMatch&content-lang=en
Swapping the inputs may give you that column? but does it helps you?
Vaibhav
One Star

Re: tFuzzyMatch : Can't add field from look up table inside output table

Thanks for the feedback.
Comparison work great.
I only want to take opportunity of the module to embed a new field which I will need later (and which is inside lookup table)
Maybe I just can't do this but the strange thing is the arrows that make me think it should be possible. (Maybe on enterprise version ?)
Anyway, thanks
Four Stars

Re: tFuzzyMatch : Can't add field from look up table inside output table

May be you get the fields from main, and after fuzzy lookup you can have same with inner join using tMap with lookup and get it again.
Vaibhav
One Star

Re: tFuzzyMatch : Can't add field from look up table inside output table

OK thanks, I'll try this.