Dashboards & Visualizations

How to remove unwanted row?

KalebeRS
Explorer

Hello,

 

I have this column named pverProduct. For some reason the header of the csv file got in the middle of the result. Is there a way to remove the unwanted row(pverProduct)?

index="" host= sourcetype=csv source=C:\\
| table pverProduct
| dedup pverProduct

 

KalebeRS_1-1690533284350.png

 

 

Labels (1)
0 Karma
1 Solution

jotne
Builder

Try add this as last line.  It will remove the line, but this is data that is already in your table.

 

| search pverProduct!="pverProduct"

 

View solution in original post

Tags (1)

gcusello
SplunkTrust
SplunkTrust

Hi @KalebeRS ,

please try:

index="" host= sourcetype=csv source=C:\\ pverProduct!="pverProduct"
| table pverProduct
| dedup pverProduct

Ciao.

Giuseppe

0 Karma

jotne
Builder

Try add this as last line.  It will remove the line, but this is data that is already in your table.

 

| search pverProduct!="pverProduct"

 

Tags (1)
Get Updates on the Splunk Community!

Celebrating Fast Lane: 2025 Authorized Learning Partner of the Year

At .conf25, Splunk proudly recognized Fast Lane as the 2025 Authorized Learning Partner of the Year. This ...

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 ...