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.
