topic Re: Input multiple csv files in Getting Data In

Input multiple csv files

darioapis — Thu, 24 Jan 2019 12:13:40 GMT

Hi, I am trying to load multiple csv files to my search result. I know that can be done using the append command, but I am wonder if it can be done using something like thisinputcsv some*.csv. Thanks

Re: Input multiple csv files

richgalloway — Fri, 25 Jan 2019 13:37:43 GMT

There could be many ways to do that, but it depends on your use case and data. More detail would be helpful.

One option: | inputlookup file1.csv | inputlookup append=t file2.csv | ....

Re: Input multiple csv files

woodcock — Fri, 25 Jan 2019 15:21:39 GMT

If your files have more thank 50500 lines, other methods may truncate your events due to subsearch limits. The only what that I have found to pull in multiple CSVs without truncation on any version of Splunk is like this:

|inputlookup file1.csv
| appendpipe [ |inputlookup file2.csv ]
| appendpipe [ |inputlookup file3.csv ]
...
| appendpipe [ |inputlookup fileN.csv ]

Re: Input multiple csv files

sbaror11 — Wed, 17 Feb 2021 21:29:06 GMT

I need to read csv files *dynamically*. That is, every week a new file is added. So every week I need to read an additional file. Is there a way to build an automated dynamic command?
I can get the list of all files with rest/servicesNS/-/-/data/lookup-table-files | search title="file*.csv".
But what's next?

my current workaround is to build the cmd using the above, and then copying it to the spl line and running it. This is not automatic of course.

All the examples above are for a static list of files.