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 not giviing required output in Talend

I have a workflow in which i have 2 files.

First file has below data separated by delimiter

Name;Department
wdci pty ltd1;Sales
talend Open Studiofdger;Marketing
Salesforce ;Design
wdci pty ltd1;Automation
Salesforce1;Marketing
wdci pvt limited;Design
Roger Federer;Tennis
Maradona;Soccer

second file has below data

nam;Sales
wdci pty ltd1;195
talend Open Studiofdger;188
Salesforce ;159
MyName;129

When i create a talend job to do fuzzy matching, its isn't giving me correct output.

Below is my talend workflow

0683p000009MApG.jpg

 

Below is output

 

Starting job FuzzyMatch at 11:54 13/04/2017.

[statistics] connecting to socket on port 3777
[statistics] connected
Name|Department|1,2|nam,MyName
wdci pty ltd1|Sales|0|wdci pty ltd1
talend Open Studiofdger|Marketing|0|talend Open Studiofdger
Salesforce |Design|0|Salesforce 
wdci pty ltd1|Automation|0|wdci pty ltd1
Salesforce1|Marketing|1|Salesforce 
wdci pvt limited|Design||
Roger Federer|Tennis||
Maradona|Soccer||
[statistics] disconnected
Job FuzzyMatch ended at 11:54 13/04/2017. [exit code=0]

What i believe is that last two records should not be appearing in the output. Any suggestion?

Labels (3)
2 Replies
Anonymous
Not applicable
Author

Hi,

 

In my opinion it's the proper functioning.

 

You have a main with 7 rows, so in the output you keep the 7 rows and the Fuzzy Component says there's nothing in your lookup matching for the last two lines.

 

You just have to put a filter component and it should be ok no ?

 

 

Sid3
Contributor III
Contributor III

So you mean when there is no match you don't need those records to your target flow? is it correct?