Splunk Enterprise

Lookup comparison

iamtheclient20
Explorer

Hello,

Example I have 2 lookups, first.csv and second.csv

first.csv have 1 column name=fruit_name and with multivalue

first.csv

fruit_name
apple
banana
melon
mango
grapes
guyabano
coconut



second.csv have 2 column fruits and remarks with multivalue under fruits column

fruits

remarks

apple
mango
guyabano

visible


How can i check if all the values of second.csv (apple,mango,guyabano) are present in the column fruit_name under first.csv then echo out the remarks with the value of visible


Thanks in advance

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

how have you set up your csv files so that they have multivalue fields?

0 Karma
Get Updates on the Splunk Community!

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...

Secure Your Future: Mastering Upgrade Readiness for Splunk 10

Spotlight: The Splunk Health Assistant Add-On  The Splunk Health Assistant Add-On is your ultimate companion ...

Observability Unlocked: Kubernetes & Cloud Monitoring with Splunk IM

Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team on ...