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

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