Splunk Search
×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question

conditionally using random()

abby_xr
Splunk Employee
Splunk Employee
‎06-21-2021 08:44 AM

Based on my dataset, I have 10 items in total and I wanna generate a new field randomly for each different item. 

E.g.:

basesearch

| eval new_field=case(
FieldA=item_1,(random() % 4) + 1,
FieldA=item_2,(random() % 4) + 1,
FieldA=item_3, (random() % 4) + 1,
......
FieldA=item_10, (random() % 4) + 1)

but the results of new_field for each item are different. what I want is the newfield_1 is fixed, for example,

"newfield_1=(random() % 4) + 1, if fiedA==item_1: FieldA=newfield_1 (newfield_1 won't change again)"

How can I keep consistent for the different items? Thank you for the help.

Labels (2)
Labels
0 Karma
Reply
Get Updates on the Splunk Community!

New Year. New Skills. New Course Releases from Splunk Education

A new year often inspires reflection—and reinvention. Whether your goals include strengthening your security ...

Splunk and TLS: It doesn't have to be too hard

Overview Creating a TLS cert for Splunk usage is pretty much standard openssl.  To make life better, use an ...

Faster Insights with AI, Streamlined Cloud-Native Operations, and More New Lantern ...

Splunk Lantern is a Splunk customer success center that provides practical guidance from Splunk experts on key ...