title: Comparing values in two columns of two different Splunk searches
body: <p>I am new to splunk and facing an issue in comparing values in two columns of two different queries.</p>
  
  <p><strong>Query 1</strong></p>
  
  <pre><code>index="abc_ndx" source="*/jkdhgsdjk.log" call_id="**" A_to="**" A_from="**" | transaction call_id keepevicted=true | search "xyz event:" | table _time, call_id, A_from, A_to | rename call_id as Call_id, A_from as From, A_to as To
  </code></pre>
  
  <p><strong>Query 2</strong></p>
  
  <pre><code>index="abc_ndx" source="*/ jkdhgsdjk.log" call_id="**" B_to="**" B_from="**" | transaction call_id keepevicted=true | search " xyz event:"| table _time, call_id, B_from, B_to | rename call_id as Call_id, B_from as From, B_to as To
  </code></pre>
  
  <p>These are my two different queries. I want to compare each values in <code>A_from</code> column with each values in <code>B_from</code> column and if the value matches, then display the those values of <code>A_from</code>.</p>
  
  <p>Is it possible?</p>
  
  <p>I have run the two queries separately and exported the results of each into csv and used <code>vlookup</code> function. But the problem is there is a <strong><em>limit of max 10000 rows</em></strong> of data which can be exported and so I miss out lots of data as my data search has more than 10000 records. 
  Any help?</p>