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

View solution in original post

aashish_122001
Explorer

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

cheers
Aashish

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!