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
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...