I need to combine two results names into one

[streetdoc123]

So search command | stats count by user | want to rename or combine the two results into same name

i.e.
User ** **Count
eid 1234abc 2
Bobbie Smith 12

[streetdoc123]

I'll try it. Thanks for the help.

[streetdoc123]

Thanks, I'll try that.

[kmaron · Accepted solution]

Try this:

eval UserCount = User.Count

[somesoni2]

Assuming you'll not always get two rows from your stats, how do you relate a name with user_id? Do you've any lookup or any other source which contains this mapping?

[streetdoc123]

I don't know what you are asking. The results show up as a user ID, then the user name appears in the table value as well. I have several that show up as both name and eID, which I need to combine them for alert reporting purposes. The count shows them both as well.

User Count
Bobbie Smith 12
eID 1234abc . (Also Bobbie Smith) 2
Not sure if the format for the tables and columns are showing up well enough.

[DalJeanis]

@streetdoc123 - @somesoni2 is asking, "How will the search program determine which user name goes with which id?"

Is there a table somewhere that has...

eid         Name
1234abc    Bobbie Smith
2345def    J Jonah Jamieson

[cmerriman]

Is this a multi value field? Can you provide syntax that is getting you to this point ?