Splunk Search

Convert multiple value to single value.

abhishekpatel2
Explorer

I want to map multiple value field to one single value field.

Ex:

COL1     |     COL2

VAL1     |     Val11

                      Val12

VAL2     |     Val21

                      Val22

                     Val23

And the output I want is:

COL1     |     COL2

VAL1     |     Val11,VAL12

VAL1     |     Val21,VAL22,VAL23

 

Labels (1)
0 Karma

venkatasri
SplunkTrust
SplunkTrust

Hi @abhishekpatel2 

Can you try this?

<your_search_goes_here> 
| eval new_COL2=mvjoin(COL2,",") 
| table COL1 new_COL2

---

An upvote would be appreciated and Accept solution if this reply helps!

Get Updates on the Splunk Community!

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

&#x1f342; Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...