Getting Data In

Import csv with header that change column order between different files

edoardo_vicendo
Builder

Hello,

We have to import a csv file that always contains the same amount of column (and corresponding values), but the system that generates it sometimes change the order of the header columns, like this:

 

File01.csv

field01,field02,field03

 

 

 

File02.csv

field03,field01,field02

 

 

Is there any way to ingest the file without using in props.conf this set-up?

INDEXED_EXTRACTIONS=csv

 

The reason is that using the INDEXED_EXTRACTIONS Splunk is adding those fields in the .tsidx and we would like to avoid that.

 

Thanks a lot,

Edoardo

0 Karma
Get Updates on the Splunk Community!

Manual Instrumentation with Splunk Observability Cloud: The What and Why

If you've ever worked with distributed systems, you’ve likely felt the pain of a frontend throwing errors, ...

Full-Stack Security in Financial Services: AppDynamics, Cisco Secure Application, and ...

Full-Stack Security in Financial Services: AppDynamics, Cisco Secure Application, and Splunk ES Protecting a ...

It's Customer Success Time at .conf25

Hello Splunkers,   Ready for .conf25? The customer success and experience team is and can’t wait to see you ...