Reference > Prepare Methods
shuffle(value)
Definition
Object shuffle(Object value)
Parameter Definition
Name |
Type |
Description |
value |
Object |
|
Example
| Prepare *,shuffle(Price) as Sample from SampleData Partition by Symbol
|
| +------+--------+-----+------+
|Symbol|Sequence|Price|Sample|
+------+--------+-----+------+
|CAT |1 |50.0 |54.0 |
|CAT |2 |54.0 |50.0 |
|CAT |3 |52.0 |57.0 |
|CAT |4 |52.0 |52.0 |
|CAT |5 !null !null |
|CAT |6 |57.0 |52.0 |
|IBM |1 |20.0 |22.0 |
|IBM |2 |24.0 |27.0 |
|IBM |3 |22.0 |20.0 |
|IBM |4 |27.0 !null |
|IBM |5 !null |24.0 |
+------+--------+-----+------+
|