How to combine tables with identical fields?

[jpfrancetic]

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                                    

[VatsalJagani]

@jpfrancetic - Try the below search:

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

[ITWhisperer · Accepted solution]

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