How do I remove empty rows in the result fields?

[leninkp3005]

Folks !!

I'm struggling with removing empty rows from the result fields in my results. In my results, i've got many empty rows.

Kindly assist this case.

Unable to upload/attach my sheet, sorry for the inconvenience.

Cheers,
Lenin K

[iamarkaprabha · Accepted solution]

Hi leninkp3005,

You can use field!=null for this one.
If you want to use those null fields you can use fillnull command
fillnull fills all the null values in the results of a specific field/fields/all fields with a value (defaulted as 0)
|fillnull FIELD value="N/A"

[leninkp3005]

Hi,
Used that last query. It's working fine.

Thanks.

[iamarkaprabha]

You are welcome!

[kamlesh_vaghela]

@leninkp3005

you can use where or search after your result.

|where isnotnull(field1)

OR

|search field1=*

[leninkp3005]

Hello Kamlesh,

It's working for me, thanks for your support.

Cheers,
Lenin Kp