Splunk Search

How to merge value from multiple fields into a single field (Field = Value format)?

tehong
Explorer

Hi. 

I want to merge data from multiple fields into a single field.

If you have a table like the following

fieldA, fieldB, fieldC
------------------------------
valueA, valueB, valueC

The expected output is as follows. I want to combine them into a single field in the Field = Value format.

merge_data = "fieldA = valueA, fieldB = valueB, fieldC = valueC"

I think it can be done using multivalue OR foreach, but I don't know how to code it.

Thanks in advance!!

 

 

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| eval merge_data=","
| foreach field*
    [| eval merge_data=merge_data."<<FIELD>>"."=\"".trim(<<FIELD>>)."\","]
| eval merge_data=trim(merge_data,",")

View solution in original post

tehong
Explorer

Thanks perfect!!

ITWhisperer
SplunkTrust
SplunkTrust
| eval merge_data=","
| foreach field*
    [| eval merge_data=merge_data."<<FIELD>>"."=\"".trim(<<FIELD>>)."\","]
| eval merge_data=trim(merge_data,",")
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 ...