How to Filter Null Records in Report

[kiran4splunk]

Hi All,
How to Filter Null Records in Report.

Please find the Below Search and Report.

sourcetype="informatica" Instancename="[TO1_HR_APP_ASSIGNMENTS1]" | table Instancename,OutputRows,AffectedRows,AppliedRows

Instancename OutputRows AffectedRows AppliedRows

[TO1_HR_APP_ASSIGNMENTS1] [5497] [5497] [5497]

[TO1_HR_APP_ASSIGNMENTS1]

[TO1_HR_APP_ASSIGNMENTS1]

[TO1_HR_APP_ASSIGNMENTS1] [5497] [5497] [5497]

[TO1_HR_APP_ASSIGNMENTS1]

[TO1_HR_APP_ASSIGNMENTS1]

Please Reply ASAP.

Thanks and Regards
Kiran Kumar

[Ayn]

Well if you're not interested in the cases where OutputRows,AffectedRows,AppliedRows don't contain anything, just add it to the search?

sourcetype="informatica" Instancename="[TO1_HR_APP_ASSIGNMENTS1]" OutputRows="*" AffectedRows="*" AppliedRows="*" | ...