remove unwanted records from output

[avi123]

Expected Output:

Ticket ID   Priority   Status

1234           P1            Closed

5678

8765            P2            Closed

[deepakc]

It would be better to give us some more context - its helps with trying to help and answer you question.

I guess you are trying to remove / filter out some data?

This is just guessing on what you maybe wanting to do.

This is an example using make results, this filters the ticket_id=5678 (so apply same princples for your code) 

| makeresults | eval _raw="ticket_id, priority,status
123,P1,Closed
5678,,
8765,P2,Closed"
| multikv forceheader=1
| search ticket_id!=5678
| table ticket_id, priority, status