Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
7 Replies
Anonymous
Not applicable
Author

Can you pl put a screenshot? of the job and component?
What is the problem that you are facing?
Vaibhav
Anonymous
Not applicable
Author

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.
0683p000009MEBO.jpg
Anonymous
Not applicable
Author

Sorry, I forgot one picture...
0683p000009MEBT.jpg
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

OK thanks, I'll try this.