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.
Could you also post your expected result on forum, please?
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.