How to incorporate loop concept into fuzzy match procedure.

Five Stars

How to incorporate loop concept into fuzzy match procedure.

I have two files like below. I want to use tfuzzymatch to compare the company column in main file to the CompanyName column in LookupFile by the same ID.  I think that I probably can use tforeach or tloop to loop the fuzzymatch within the same ID. But I do not know how to build my job. Could anyone help me? Thanks a lot.

fuzzy.PNG

Moderator

Re: How to incorporate loop concept into fuzzy match procedure.

Hi,

Could you also post your expected result on forum, please?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: How to incorporate loop concept into fuzzy match procedure.

Hi,

 

Thank you very much. 

 

I have figured it out. I used tflowtoIterate and a subjob components to build this job. Thanks a lot. It is first time for me to use subjob component. 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read