topic Re: AND in If statement in Splunk Search

AND in If statement

rlautman — Tue, 03 Sep 2013 10:17:24 GMT

I have a set of logs showing order journeys between countries - I want to create a report that show the destination country of the order or, if the order is staying within the country of origin, will show this order as a local supply order. To assess whether the order is local supply I need to evaluate 2 fields, I have written if statements with an OR condition but I am not sure how to use an AND condition within the if statement - can anyone suggest how I would do this?

Re: AND in If statement

Ayn — Tue, 03 Sep 2013 10:45:00 GMT

Could you show examples? Without any other info I'd just say "just use AND instead of OR", but I'm guessing there's more to your question than that.

Re: AND in If statement

rlautman — Tue, 03 Sep 2013 11:06:23 GMT

This is the statement I've tried using, but the issue may not be with the AND:

eval OrderType=if((OriginCountry="IRL") AND (DestinationCountry="IRL"),LocalSupply,External) | stats count by OrderType

This query is currently showing no results.

Ideally I would like to have a report where I can show all orders and their origin countries within a specific time frame, and if they are 'Local Supply' the origincountry will be renamed Local Supply and all other orders will be displayed with their origincountry, but I'll walk before I run!

Re: AND in If statement

rlautman — Tue, 03 Sep 2013 11:12:22 GMT

Ah I have spotted my own mistake, a simple matter of missing quotation marks around LocalSupply and External - I've managed to make the country display as LocalSupply, I'm now running 🙂

Re: AND in If statement

Ayn — Tue, 03 Sep 2013 11:12:43 GMT

Are LocalSupply and External supposed to be field names or strings? Because right now you're referring to field names, so if those fields don't exist, you will get empty results.