https://community.splunk.com/t5/Splunk-Search/How-do-I-find-common-values-from-the-results-of-two-searches/m-p/179890#M51786 <P>use <CODE>appendcols</CODE> command to do it</P> <PRE><CODE> Index=list1 source=your_source_name sourcetype=your_sourcetype_name| ...| appendcols [ search Index=list2 source=your_source_name sourcetype=your_sourcetype_name | ... ]| appendcols [ search Index=list3 source=your_source_name sourcetype=your_sourcetype_name | ... ] </CODE></PRE> Sun, 28 Jun 2015 06:15:59 GMT fdi01 2015-06-28T06:15:59Z https://community.splunk.com/t5/Splunk-Search/How-do-I-find-common-values-from-the-results-of-two-searches/m-p/179889#M51785 <P>Hi all, </P> <P>I have a use case. I have a list of the top viewed products for the last 3 months individually. Now, I want to take the common values from the 3 results and want to have the trend for those common values. Which command do I have to use in a search? Please provide suggestions as I am new to Splunk.</P> <P>Thanks in advance.</P> Sun, 28 Jun 2015 05:52:48 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-find-common-values-from-the-results-of-two-searches/m-p/179889#M51785 avis1119 2015-06-28T05:52:48Z https://community.splunk.com/t5/Splunk-Search/How-do-I-find-common-values-from-the-results-of-two-searches/m-p/179890#M51786 <P>use <CODE>appendcols</CODE> command to do it</P> <PRE><CODE> Index=list1 source=your_source_name sourcetype=your_sourcetype_name| ...| appendcols [ search Index=list2 source=your_source_name sourcetype=your_sourcetype_name | ... ]| appendcols [ search Index=list3 source=your_source_name sourcetype=your_sourcetype_name | ... ] </CODE></PRE> Sun, 28 Jun 2015 06:15:59 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-find-common-values-from-the-results-of-two-searches/m-p/179890#M51786 fdi01 2015-06-28T06:15:59Z