topic Re: Adding results, fields from two different queries in Splunk Search https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154226#M43353 <P>Try <CODE>appendcols</CODE></P> <PRE><CODE>query1 | appendcols [ search query2] | eval grandTotal = total1 + total2 </CODE></PRE> Sun, 24 Nov 2013 05:11:44 GMT lguinn2 2013-11-24T05:11:44Z Adding results, fields from two different queries https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154225#M43352 <P>I have two completely different queries which of them output fields like below</P> <P>The output of the fields will be just one value</P> <PRE> Query 1 - ...|table total1 Query 2 - ...|table total2 </PRE> <P>Now I want to add these two fields total1 and total2 and display it. </P> <P>How can I achieve this in a single query?</P> Sun, 24 Nov 2013 05:08:06 GMT https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154225#M43352 pradeepkumarg 2013-11-24T05:08:06Z Re: Adding results, fields from two different queries https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154226#M43353 <P>Try <CODE>appendcols</CODE></P> <PRE><CODE>query1 | appendcols [ search query2] | eval grandTotal = total1 + total2 </CODE></PRE> Sun, 24 Nov 2013 05:11:44 GMT https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154226#M43353 lguinn2 2013-11-24T05:11:44Z Re: Adding results, fields from two different queries https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154227#M43354 <P>Perfect. Thanks much!</P> <P>Will it work the same way for 3 queries? My actual requirement was for 3 queries. I'm yet to try that. Hope it works <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sun, 24 Nov 2013 05:31:45 GMT https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154227#M43354 pradeepkumarg 2013-11-24T05:31:45Z Re: Adding results, fields from two different queries https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154228#M43355 <P>It did.. Thanks!</P> Sun, 24 Nov 2013 06:30:33 GMT https://community.splunk.com/t5/Splunk-Search/Adding-results-fields-from-two-different-queries/m-p/154228#M43355 pradeepkumarg 2013-11-24T06:30:33Z