https://community.cloudera.com/t5/Support-Questions/merge-too-csv-files-in-nifi/m-p/229264#M191121 <P><A rel="user" href="https://community.cloudera.com/users/84157/rajatpuchnanda15.html" nodeid="84157" target="_blank">@rajat puchnanda</A> </P><P>Merging that you are expecting is a lookup in the departments table with department id, </P><P>For your case you can use LookUpRecord processor to look for deptid and add get the salary,email and add to the record.</P><P>LookupRecord processor supports all these controller services to </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="78410-lookuprecord-controller-services.png" style="width: 948px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15120iF700AEA8D31A2CA2/image-size/medium?v=v2&amp;px=400" role="button" title="78410-lookuprecord-controller-services.png" alt="78410-lookuprecord-controller-services.png" /></span></P><P>Load your inputfile2 in one of the lookup services then use LookupRecord to look for deptid value then add the value to the record.</P><P>Refer to <A href="https://community.hortonworks.com/articles/138632/data-flow-enrichment-with-nifi-lookuprecord-proces.html" target="_blank" rel="nofollow noopener noreferrer">this</A> and <A href="https://community.hortonworks.com/questions/174144/lookuprecord-and-simplecsvfilelookupservice-in-nif.html" target="_blank" rel="nofollow noopener noreferrer">this</A> links to get more details regarding configuration and working with LookupRecord processor.</P> Sun, 18 Aug 2019 00:59:05 GMT Shu_ashu 2019-08-18T00:59:05Z