Splunk Search

combining 2 rows in to a single row



I was trying to add 2 rows in to a single row . After combining,I am getting results for 1st column .but not for 2nd result .Something wrong here ?

host=t-fus* ("SRCreateRequest"  OR "SRPublishRequest" OR "SRUpdateRequest" OR "JNPRCreateSRPublish" OR "JNPRPostSRUpdate" OR "JNPRUpdateSRPublish") 
(Publisher: Completed OR fallacy )
| rename JNPRCreateSRPublish as SRCreateRequest
| rename JNPRPostSRUpdate as SRPublishRequest 
| rename JNPRUpdateSRPublish as SRUpdateRequest
| rex "(?<API> SRCreateRequest | SRPublishRequest | SRUpdateRequest )"
| rex "(?<status>Completed| fallacy)"
| where isnotnull(status) 
| append 
    [| makeresults 
    | eval API=split(" SRCreateRequest | SRPublishRequest | SRUpdateRequest ", "|") 
    | mvexpand API] 
| chart count as count1 by API,status 
| table API, Completed, Error
| fillnull value=0 Error, Completed


Labels (1)
0 Karma
Get Updates on the Splunk Community!

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...

DevSecOps: Why You Should Care and How To Get Started

 WATCH NOW In this Tech Talk we will talk about what people mean by DevSecOps and deep dive into the different ...

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...