Splunk Search

How to rewrite the id with a type value of 2 to the id value with a type value of 1 for data with the same axid value?

tehong
Explorer

Hi experts,

Could you please advise me about SPL?

Given the data below, I would like to rewrite the id with a type value of 2 to the id value with a type value of 1 for data with the same axid value.

----------------------
axid, id, type
----------------------
0001,abc,1
0001,def,2
0001,ghi,2
0002,jkl,1
0002,mno,2
0002,pqr,2

Expected results follow

----------------------
axid, id, type
----------------------
0001,abc,1
0001,abc,2
0001,abc,2
0002,jkl,1
0002,jkl,2
0002,jkl,2

Thanks in adance!!

Labels (1)
Tags (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| eval type1id=if(type=1,id,null())
| eventstats values(type1id) as id by axid

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| eval type1id=if(type=1,id,null())
| eventstats values(type1id) as id by axid

tehong
Explorer

Perfect Thanks Whisperer!

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...