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!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...