Getting Data In

comparing two csv files having similar fields

karthikTIL
Path Finder

I have two files, ping.csv and booking.csv
ping.csv has fields-> Device_NAME,IP,result
booking.csv has fields -> Device_NAME,IP,engaged.
"Device_NAME" and "IP" fields have same similar values in both files.

My question is,i need to display "Device_NAME","IP" field and "engaged" field from "booking.csv", if the corresponding device_name and IP fields have result=down in ping.csv.
please let me know how do i search.

Tags (2)
1 Solution

laithmurad
Path Finder

Looks like you're looking for the join command, assuming both csv files are already indexed by splunk you should be able to that with a query similar to this:

source="ping.csv" result=down | join Device_NAME,IP [search source="booking.csv"] | table Device_NAME,IP,engaged

You can find more information about the join command here: http://docs.splunk.com/Documentation/Splunk/6.0/SearchReference/Join

Hope this helps.

View solution in original post

laithmurad
Path Finder

Looks like you're looking for the join command, assuming both csv files are already indexed by splunk you should be able to that with a query similar to this:

source="ping.csv" result=down | join Device_NAME,IP [search source="booking.csv"] | table Device_NAME,IP,engaged

You can find more information about the join command here: http://docs.splunk.com/Documentation/Splunk/6.0/SearchReference/Join

Hope this helps.

karthikTIL
Path Finder

Thanks.I tried below command and it also worked.
source="booking.csv" [search source="ping.csv" RESULT="Down"|Table Device_NAME ]| Table IP,Engaged

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...