How to concatenate results from the same field?

[praspai]

Hi,

I want to concatenate results from same field into string. How can I do that?

e..g

|inputlookup user.csv| table User 

User 
------------
User 1
User 2
User 3

Users = User 1+User2+User3

[kamlesh_vaghela · Accepted solution]

@praspai

Can you please try this?

|inputlookup user.csv| stats values(User) as Users | nomv Users

[praspai]

Thanks. It works.

[kamlesh_vaghela]

@praspai
Glad to help you.
Can you please accept this answer?