Splunk Search

lookup input value null

shayhibah
Path Finder

Hey,

I am trying to work with lookup table where input contains 3 fields (A,B,C) and output is D

Lookup table structure:

ABCD
ab d

 

Here is my configuration:

props.conf:

LOOKUP-result = lookup_table A B C OUTPUT D

transform.conf:

[lookup_table]

filename...

 

When I run query where there is no field named C (for example: A=a, B=b), the returned output is "a" which is not what I expect it to be "d".

What am I missing here? How can I fix it?

Labels (1)
0 Karma

thambisetty
SplunkTrust
SplunkTrust

Try something like below:

LOOKUP-result = lookup_table A as A, B as B, C as C OUTPUT D

————————————
If this helps, give a like below.
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...