https://community.splunk.com/t5/Getting-Data-In/Joining-two-csv-files/m-p/359380#M93358 <P>try this:</P> <PRE><CODE>| savedsearch file2|join type=left ID [| savedsearch file1] </CODE></PRE> Wed, 07 Feb 2018 06:21:49 GMT 493669 2018-02-07T06:21:49Z https://community.splunk.com/t5/Getting-Data-In/Joining-two-csv-files/m-p/359379#M93357 <P>Hi, I have two CSV files that I want to be joined ex. file1 and file2 there are values in file2 which do not have a match in file1 but in the final result I want these values to be included. </P> <P>Sample spl :<BR /> | savedsearch file1<BR /> | join type=outer ID [| savedsearch file2]</P> Wed, 07 Feb 2018 06:18:32 GMT https://community.splunk.com/t5/Getting-Data-In/Joining-two-csv-files/m-p/359379#M93357 mjlsnombrado 2018-02-07T06:18:32Z https://community.splunk.com/t5/Getting-Data-In/Joining-two-csv-files/m-p/359380#M93358 <P>try this:</P> <PRE><CODE>| savedsearch file2|join type=left ID [| savedsearch file1] </CODE></PRE> Wed, 07 Feb 2018 06:21:49 GMT https://community.splunk.com/t5/Getting-Data-In/Joining-two-csv-files/m-p/359380#M93358 493669 2018-02-07T06:21:49Z