https://community.splunk.com/t5/Getting-Data-In/How-to-create-a-consolidated-report/m-p/241080#M46791 <P>I have 5 input CSV files received everyday. How can they be appended and stored everyday as one report when received? On any particular day, I want to have the details extracted from the 5 CSV input files, consolidate them in one report, and send this out in an email. How do I achieve this?</P> <P>Thanks in advance!</P> Fri, 19 Aug 2016 17:44:40 GMT sai1234 2016-08-19T17:44:40Z https://community.splunk.com/t5/Getting-Data-In/How-to-create-a-consolidated-report/m-p/241080#M46791 <P>I have 5 input CSV files received everyday. How can they be appended and stored everyday as one report when received? On any particular day, I want to have the details extracted from the 5 CSV input files, consolidate them in one report, and send this out in an email. How do I achieve this?</P> <P>Thanks in advance!</P> Fri, 19 Aug 2016 17:44:40 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-create-a-consolidated-report/m-p/241080#M46791 sai1234 2016-08-19T17:44:40Z https://community.splunk.com/t5/Getting-Data-In/How-to-create-a-consolidated-report/m-p/241081#M46792 <P>Something like this may work.</P> <PRE><CODE>| inputlookup file1.csv | append [| inputlookup file2.csv] | append | inputlookup file3.csv] and so on | commands to generate your report </CODE></PRE> <P>Once you have the right report, you can schedule it to run automatically<BR /> <A href="http://docs.splunk.com/Documentation/Splunk/6.4.2/Report/Schedulereports">http://docs.splunk.com/Documentation/Splunk/6.4.2/Report/Schedulereports</A></P> Fri, 19 Aug 2016 18:01:44 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-create-a-consolidated-report/m-p/241081#M46792 sundareshr 2016-08-19T18:01:44Z