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!!
| eval type1id=if(type=1,id,null())
| eventstats values(type1id) as id by axid
| eval type1id=if(type=1,id,null())
| eventstats values(type1id) as id by axid
Perfect Thanks Whisperer!