Splunk Search

Remove original and duplicate items from a query

francesco1g
Engager
Hi, from two columns, in order to create a report, i need to remove the elements that are present twice, not only remove the duplicates (dedup is not useful because it only removes duplicates) but also the original elements, for example:

Table A | Table B
10.10       10.2
10.21       10.32
10.2          10.3
10.60       10.21

Table C (result)
10.10
10.32
10.3
10.60



thanks for your help
Labels (1)
Tags (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

 

| eval tableC=mvappend(tableA,tableB)
| stats count by tableC
| where count=1
| fields - count

 

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

 

| eval tableC=mvappend(tableA,tableB)
| stats count by tableC
| where count=1
| fields - count

 

0 Karma
Get Updates on the Splunk Community!

What's New in Splunk Observability Cloud and Splunk AppDynamics - May 2025

This month, we’re delivering several new innovations in Splunk Observability Cloud and Splunk AppDynamics ...

Getting Started with Splunk Artificial Intelligence, Insights for Nonprofits, and ...

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

Splunk Observability Cloud’s AI Assistant in Action Series: Identifying Unknown ...

Agentic AI powers the Splunk AI Assistant within the Splunk Observability Cloud interface to help you quickly ...