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.
... View more
