How to incorporate loop concept into fuzzy match procedure.

[Anonymous]

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.

[Anonymous]

Hi,

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

Best regards

Sabrina

[Anonymous]

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.