Can I use data from other rows and set them to a different row who have the same key?

[yoshilog]

Hi everyone, 

I would like to ask if it's possible to use data from another row, to be set as the value of a different row with the same key... Such as in the table below. 

id	username	status
XC2345		completed
XC2345		in progress
XC2345	killjoy	started
ZC9999		in progress
ZC9999	jett	started

In the example above, I would like to set the values for usernames of each row with the same id to the same as the one with values, for them to become like this: 

id	username	status
XC2345	killjoy	completed
XC2345	killjoy	in progress
XC2345	killjoy	started
ZC9999	jett	in progress
ZC9999	jett	started

Would above be possible through eval or another function? 

[manjunathmeti · Accepted solution]

hi @yoshilog,
Yes, you can use event stats with the last function.

your_Search | eventstats last(username) as username by id

If this reply helps you, an upvote/like would be appreciated.

[yoshilog]

Thank you. It worked.