Splunk Search

Is it possible to use where command in Data Model?

wilhelmF
Path Finder

I have datamodel and I want to create a child datamodel based on a field comparison. In a normal search I would use a where command but in the constraints I only can use a search command. My question is there a way to do it without an eval expression in a field?

0 Karma

Yunagi
Communicator

How about you create a calculated field under Settings/Fields? Something like:

Name: match
Eval expression: if(field1==field2,"yes","no")

Then you can create your child datamodel based on the constraint:

match="yes"

DalJeanis
Legend

@Yunagi - This is a correct way to go about this, although it does not meet OP's requirement of not having an eval in a field.

@wilhelmf - Not sure what your reason for not wanting the eval field. If you are just worrying about complicating the data model from a user's point of view, then you can hide the calculated field.

0 Karma
Get Updates on the Splunk Community!

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

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

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...