https://community.splunk.com/t5/Splunk-Search/Show-only-non-zero-fields/m-p/295546#M166389 <P>Hi,</P> <P>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:<BR /> | fields test* | where test* &gt; 0</P> <P>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.</P> Mon, 21 Aug 2017 03:43:04 GMT ericchaucl 2017-08-21T03:43:04Z https://community.splunk.com/t5/Splunk-Search/Show-only-non-zero-fields/m-p/295546#M166389 <P>Hi,</P> <P>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:<BR /> | fields test* | where test* &gt; 0</P> <P>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.</P> Mon, 21 Aug 2017 03:43:04 GMT https://community.splunk.com/t5/Splunk-Search/Show-only-non-zero-fields/m-p/295546#M166389 ericchaucl 2017-08-21T03:43:04Z https://community.splunk.com/t5/Splunk-Search/Show-only-non-zero-fields/m-p/295547#M166390 <P>Hey, </P> <PRE><CODE>| table test* | transpose | rename column as Test "row 1" as count | where count &gt; 0 </CODE></PRE> <P>3no.</P> Mon, 21 Aug 2017 09:37:51 GMT https://community.splunk.com/t5/Splunk-Search/Show-only-non-zero-fields/m-p/295547#M166390 3no 2017-08-21T09:37:51Z https://community.splunk.com/t5/Splunk-Search/Show-only-non-zero-fields/m-p/295548#M166391 <P>It works! Million thanks!</P> Mon, 21 Aug 2017 09:46:28 GMT https://community.splunk.com/t5/Splunk-Search/Show-only-non-zero-fields/m-p/295548#M166391 ericchaucl 2017-08-21T09:46:28Z