Splunk Search

How to combine tables with identical fields?

jpfrancetic
Path Finder

Hi Splunk Community,

I have 2 tables I am attempting to merge together. Both tables are in csvs that I am trying to pull from. Does anyone know the command so that the data from the second table gets added to the bottom of the first?

table 1                                           table 2

a1                                                    d4 

b1                                                    e5

c3                                                     f6

Combined

a1

b2

c3

d4

e5

f6                                    

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| inputlookup table1.csv
| append [|inputlookup table2.csv]

View solution in original post

0 Karma

VatsalJagani
SplunkTrust
SplunkTrust

@jpfrancetic - Try the below search:

| inputlookup table1.csv
| inputlookup append=true table2.csv
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| inputlookup table1.csv
| append [|inputlookup table2.csv]
0 Karma
Get Updates on the Splunk Community!

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...

From Alert to Resolution: How Splunk Observability Helps SREs Navigate Critical ...

It's 3:17 AM, and your phone buzzes with an urgent alert. Wire transfer processing times have spiked, and ...