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.

[ShankerV]

Hi @Sshasnk 

Use the sample tool, where you select the Group by Column as Fund.

Many thanks

Shanker V

[DavidSkaife]

@ShankerV @Sshasnk 

The Sample tool will not work in this scenario, as N is not consistant across the funds. i.e ABC has 3 instances, LMN has 2, and XYZ has 4.

Plus the Group by option isn't applicable for 1 in N chance: