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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...