https://community.cloudera.com/t5/Support-Questions/merge-too-csv-files-in-nifi/m-p/229261#M191118 <P>@Shu</P><P>InputFile 1</P><TABLE><TBODY><TR><TD>deptid</TD><TD>firstname</TD><TD>lastname</TD></TR><TR><TD>1</TD><TD>Aman</TD><TD>Sharma</TD></TR><TR><TD>2</TD><TD>Raman</TD><TD>Verma</TD></TR></TBODY></TABLE><P> InputFile 2</P><TABLE><TBODY><TR><TD>deptid</TD><TD>salary</TD><TD>email</TD></TR><TR><TD>1</TD><TD>20000</TD><TD>abc@gmail.com</TD></TR><TR><TD>2</TD><TD>30000</TD><TD>bgf@gmail.com</TD></TR></TBODY></TABLE><P> OutputFile(By merging file1 and file2):-</P><TABLE><TBODY><TR><TD>deptid</TD><TD>firstname</TD><TD>lastname</TD><TD>salary</TD><TD>email</TD></TR><TR><TD>1</TD><TD>Aman</TD><TD>Sharma</TD><TD>20000</TD><TD>abc@gmail.com</TD></TR><TR><TD>2</TD><TD>Raman</TD><TD>Verma</TD><TD>30000</TD><TD>bgf@gmail.com</TD></TR></TBODY></TABLE><P>like the output will be grouping by deptid.</P><P>How can i get this ouput?</P> Wed, 13 Jun 2018 21:14:49 GMT rajatpuchnanda1 2018-06-13T21:14:49Z