Splunk Search

How to combine specific values from two multivalue fields

valaverdyan
Engager

I have Splunk pulling in data from a lookup and creating two multivalue fields. I want to combine these two into a third one based on the value index.

Example:
Field 1: A,B,C,D
Field 2: 1,2,3,4

I want the third field to look like this:
Field 3: A1, B2, C3, D4

The number of values in the fields are subject to change so is it possible to do this in an automated way as opposed to manually evaling it?

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Check out the mvzip function for eval.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Check out the mvzip function for eval.

---
If this reply helps you, Karma would be appreciated.
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...