Getting Data In

Joining two csv files

mjlsnombrado
Communicator

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.

Sample spl :
| savedsearch file1
| join type=outer ID [| savedsearch file2]

Tags (1)
0 Karma
1 Solution

493669
Super Champion

try this:

| savedsearch file2|join type=left ID [| savedsearch file1]

View solution in original post

0 Karma

493669
Super Champion

try this:

| savedsearch file2|join type=left ID [| savedsearch file1]
0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...