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.
Hey,
| table test* | transpose | rename column as Test "row 1" as count | where count > 0
3no.
Hey,
| table test* | transpose | rename column as Test "row 1" as count | where count > 0
3no.
It works! Million thanks!