Getting Data In

How to prevent columns in a CSV file from displaying in a report?

aashish_122001
Explorer

I have a csv file having 5 columns but I want to display only 3 columns..how can I limit the columns in the report.

While querying to index a column _time is coming with the report. I dont want this column, Can I remove this column from the report anyhow ?

Tags (4)
0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

You can remove fields by appending this to your search:

... | fields - field4 field5

Alternatively, you can list the fields you want in a table:

... | table field1 field2 field3

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

You can remove fields by appending this to your search:

... | fields - field4 field5

Alternatively, you can list the fields you want in a table:

... | table field1 field2 field3

aashish_122001
Explorer

great !!
Thanks Martin..it worked both solutions 🙂

cheers
Aashish

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...