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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to enable Data Governance
Take a peek at the definitive guide to Government Data Quality