https://community.splunk.com/t5/Splunk-Search/How-to-combine-tables-with-identical-fields/m-p/594096#M206776 <P>Hi Splunk Community,</P> <P>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?</P> <P>table 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table 2</P> <P>a1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; d4&nbsp;</P> <P>b1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e5</P> <P>c3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;f6</P> <P>Combined</P> <P>a1</P> <P>b2</P> <P>c3</P> <P>d4</P> <P>e5</P> <P>f6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Mon, 18 Apr 2022 18:18:56 GMT jpfrancetic 2022-04-18T18:18:56Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-tables-with-identical-fields/m-p/594096#M206776 <P>Hi Splunk Community,</P> <P>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?</P> <P>table 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table 2</P> <P>a1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; d4&nbsp;</P> <P>b1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e5</P> <P>c3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;f6</P> <P>Combined</P> <P>a1</P> <P>b2</P> <P>c3</P> <P>d4</P> <P>e5</P> <P>f6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Mon, 18 Apr 2022 18:18:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-tables-with-identical-fields/m-p/594096#M206776 jpfrancetic 2022-04-18T18:18:56Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-tables-with-identical-fields/m-p/594098#M206777 <LI-CODE lang="markup">| inputlookup table1.csv | append [|inputlookup table2.csv]</LI-CODE> Mon, 18 Apr 2022 16:18:08 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-tables-with-identical-fields/m-p/594098#M206777 ITWhisperer 2022-04-18T16:18:08Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-tables-with-identical-fields/m-p/594111#M206780 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/243581">@jpfrancetic</a>&nbsp;- Try the below search:</P><LI-CODE lang="markup">| inputlookup table1.csv | inputlookup append=true table2.csv</LI-CODE> Mon, 18 Apr 2022 17:04:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-tables-with-identical-fields/m-p/594111#M206780 VatsalJagani 2022-04-18T17:04:28Z