topic How to remove unwanted row? in Dashboards & Visualizations

How to remove unwanted row?

KalebeRS — Fri, 28 Jul 2023 08:35:55 GMT

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

Re: How to remove unwanted row?

jotne — Fri, 28 Jul 2023 08:42:16 GMT

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

| search pverProduct!="pverProduct"

Re: How to remove unwanted row?

gcusello — Fri, 28 Jul 2023 10:59:32 GMT

Hi @KalebeRS ,

please try:

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

Ciao.

Giuseppe