https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326726#M97356 <P>Hi sangjoonlee,</P> <P>If a1 is present in both sources then you can use <CODE>join</CODE>:</P> <P><CODE>&lt;source 1 search&gt; | join a1 [search &lt;source 2 search&gt; | table a1, b1, c1, b2, c2]</CODE></P> <P>Hope this helps.</P> Thu, 13 Apr 2017 09:03:59 GMT hhGA 2017-04-13T09:03:59Z https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326724#M97354 <P>my data is csv file</P> <P>My data below</P> <P>source = A1<BR /> field name = a1, b1, c1,...</P> <P>soruce = A2<BR /> field : a1, b2, c2,...<BR /> field : a1, b3, c3,..<BR /> field : a1, b4, c4,..<BR /> .<BR /> .<BR /> .</P> <H2>.</H2> <P>I wand to make a table</P> <P>a1, b1, c1, b2, c2<BR /> a1, b1, c1, b3, c3<BR /> a1, b1, c1, b4, c4</P> Thu, 13 Apr 2017 02:32:33 GMT https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326724#M97354 sangjoonlee 2017-04-13T02:32:33Z https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326725#M97355 <P>a1 field is in both file ? In every line ? </P> Thu, 13 Apr 2017 08:34:40 GMT https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326725#M97355 3no 2017-04-13T08:34:40Z https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326726#M97356 <P>Hi sangjoonlee,</P> <P>If a1 is present in both sources then you can use <CODE>join</CODE>:</P> <P><CODE>&lt;source 1 search&gt; | join a1 [search &lt;source 2 search&gt; | table a1, b1, c1, b2, c2]</CODE></P> <P>Hope this helps.</P> Thu, 13 Apr 2017 09:03:59 GMT https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326726#M97356 hhGA 2017-04-13T09:03:59Z https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326727#M97357 <P>thank you.</P> Sun, 16 Apr 2017 23:05:52 GMT https://community.splunk.com/t5/Splunk-Search/how-to-merge-data-from-different-two-source/m-p/326727#M97357 sangjoonlee 2017-04-16T23:05:52Z