https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131945#M55892 <P><A rel="user" href="https://community.cloudera.com/users/16344/gauravj139.html" nodeid="16344">@Gaurav Jain</A> </P><P>Please provide full use case and examples. It is difficult to provide assistance without the details. The more the better.</P> Mon, 06 Mar 2017 23:30:29 GMT MattWho 2017-03-06T23:30:29Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131943#M55890 Wed, 01 Mar 2017 19:51:09 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131943#M55890 gauravj1391 2017-03-01T19:51:09Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131944#M55891 <P>I also have the same query as want the excel data to be inserted into my database but unable to find one.</P> Mon, 06 Mar 2017 16:27:08 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131944#M55891 prakharagrawal6 2017-03-06T16:27:08Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131945#M55892 <P><A rel="user" href="https://community.cloudera.com/users/16344/gauravj139.html" nodeid="16344">@Gaurav Jain</A> </P><P>Please provide full use case and examples. It is difficult to provide assistance without the details. The more the better.</P> Mon, 06 Mar 2017 23:30:29 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131945#M55892 MattWho 2017-03-06T23:30:29Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131946#M55893 <P>@<A href="https://community.hortonworks.com/users/16344/gauravj139.html">Gaurav Jain</A></P><P>There are many ways to do it, however, assuming that you would use NiFi, you could build a flow starting with GetFile processor pointing to a folder where you have all your CSV files. Follow with MergeContent and PutFile processors.</P><P>Otherwise, it could be even simpler and without NiFi. If your files have the same structure and each has a header, then a simple shell script can extract the header from one file and remove the header from the others and just merge the content. You can easily do all this using sed unix command.</P> Tue, 07 Mar 2017 10:05:51 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-read-multiple-Excel-CSV-file-and-write-to-another/m-p/131946#M55893 cstanca 2017-03-07T10:05:51Z