Splunk Search

How to match the products within the same column and the result should be matching productnumber?

MG
Engager

The result should look like the table given below.Need to find the matching product number within customers and the result should be the matching product number, if not null. Can you please suggest

 

Customer_name Product_number Result
Customer1 P1 P1, P2
P2  
P3  
P4  
   
   
Customer 2 P2 P2
P5  
   
Customer 3 P3 Null
P6  
   
   
Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It is not clear how the result is derived from the customer name and product number. Please can you clarify?

0 Karma

MG
Engager

Out of the products, which are all the products that are not common across customers within a single division. How to find that, please

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Please can you clarify your data / example?

Is product number a multivalue field for each customer?

Customer_name Product_number

Customer 1
P1
P2
P3
P4
Customer 2
P2
P5
Customer 3
P3
P6

If so, why is the result for Customer 1 not P1, P3, P4? etc.

0 Karma
Get Updates on the Splunk Community!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...