How do you dynamically remove fields containing NULL value in a table?

[RonWonkers]

Hi,

I have a table with dynamic fields, some of these fields contain no value or NULL, how do I remove these fields when I dont know the field name beforehand?

The field names are never the same so I cannot simply do | fields - name1, name2 etc..

Is there are way to remove every field containing no value in a table?

[PickleRick · Accepted solution]

Something like this? https://community.splunk.com/t5/Splunk-Search/Removing-all-null-columns-from-stats-table/m-p/566579

[RonWonkers]

Thank you man this indeed deletes empty fields

[RonWonkers]

Thanks for your reply, I have tested it and it might work, i'm waiting for the results of any use cases.