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