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!

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...