Hi all, I am testing nifi and I am wondering if it is possible to merge two CSV files based on specific criterias. For example, given these csv files:
business.csv businessid,businessname,categoryid 1,McDonalds,1 2,Burger King,1 3,Walmart,2 4,Publix,2 categories.csv categoryid,categoryname 1,Fast food chain 2,Super market I would like to know if there is an effective way in nifi to combine both csv files using the categoryid as criteria in this case: generated.csv businessid,businessname,categoryid,categoryname 1,McDonalds,1,Fast food chain 2,Burger King,1,Fast food chain 3,Walmart,2,Super market 4,Publix,2,Super market Thank you for your time.
