I am having an field name called "JOBNAME" which contains some jobname values and some empty values(which means there is no value in some of the rows). How to remove the empty values and show only values with jobname?
Try ... | where isnotnull(JOBNAME) | ...
.