I want to pick random row from row

Sshasnk

have to pick a random from each fund

Input: 

Fund	amount	prior year amount
ABC	123	145
ABC	145	156
LMN	1456	15
LMN	159	23
XYZ	456	56
XYZ	23	14
ABC	156	45
XYZ	456	56
XYZ	23	14

Example: 

1. ABC Fund is three if you count So I have to pick a number from 1 to 3 and whichever number comes I have to pick that row value

2. In short one random value from each fund

Fund	amount	prior year amount	Random
ABC	123	145
ABC	145	156	X
ABC	156	45
LMN	1456	15	X
LMN	159	23
XYZ	456	56
XYZ	23	14	X
XYZ	456	56
XYZ	23	14

gautiergodard

Hey @Sshasnk 

Here is one way you could do this:

The rand() formula will generate a random value every run, so you can sort on it and use a sample tool after to select a value.

Hope this helps.

Random by Group.yxmd