Splunk Search

Create a variable that combines two string values

viggor
Path Finder

I have a simple question:

I have two variables foo and bar, each containing a set of strings, and I would like to create a new variable foobar which contains the union of foo and bar.

I am aware of the | set union command, but I don't seem to get it to work for this scenario.

0 Karma

Sarmbrister
Path Finder

Would an eval expression work in this case?

Example

search... | eval new_variable=foo. "" .bar

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What do you mean by "union"? Can you give an example of your fields and desired output?

Have you looked at the mvzip function?

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

somesoni2
Revered Legend

I believe you need to use mvappend command with mvdedup (to remove duplicates) with eval. If they're not multivalued fields, you have to convert them to mv first. We can suggest more accurate options if you can provide some sample values.

0 Karma
Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...