Show only non-zero fields

[ericchaucl]

Hi,

How can I run a search and only display those columns with non-zero values? For example, I have fields test1, test2, test3, .... test99, in which only test2 and test10 are non-zero. Would be perfect if there is something like this:
| fields test* | where test* > 0

P.S. To be more specific, this scenario happens when I create and apply a TFIDF model. The system automatically generate a huge # of fields with suffix _tfidf. I would like to run some query and is interested in those non-zero fields only.

[3no · Accepted solution]

Hey,

| table test* | transpose | rename column as Test "row 1" as count | where count > 0

3no.

[ericchaucl]

It works! Million thanks!