Date: Fri, 27 Nov 2020 15:24:18 +0000 (GMT) Message-ID: <1676751842.32593.1606490658250@df68ed866f50> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_32592_1272913116.1606490658250" ------=_Part_32592_1272913116.1606490658250 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html RAND Function

# RAND Function

Contents:

=20

=20
=20
=20

=20
=20

The  `RAND` function generates a random real number between 0 an= d 1. The function accepts an optional integer parameter, which causes = the same set of random numbers to be generated with each job execution.
• This function generates values of Decimal type with fifteen digits of p= recision after the decimal point. If you want to see all digits in the gene= rated value, you might need to apply a different number format. See NUMFORMAT Function.
• New random numbers are generated within the browser, after each browser= refresh, and between subsequent job executions.

Optionally, you can insert an integer as a parameter.

• When this value is present, this seed value = is used as part of the random number generator such that its output is a se= t of pseudo-random values, which are consistent between job executions.
• When the browser is refreshed, the random numbers remain consistent whe= n the seed value is present.
• This value must be a valid literal Integer value. Column references or = functions returning Integer values are not supported.

## Basic Usage

Example:

=20

derive type:single value: RAND() as:'random'

Output: For each row, generate a random number bet= ween 0 and 1 in the new `random` function.

Example with seed value:

=20

derive type:single value: RAND(2) as:'random'

Output: For each row, generate a random number bet= ween 0 and 1 in the new `random` function. The generat= ed random set of random values are consistent between job executions and ar= e, in part, governed by the seed value `2`.

## Syntax = and Arguments

There are no arguments for this function.

=20

derive type:single value: RAND([int_value])

Argument Required? Data Type Description
int_value N integer Integer literal

For more information on syntax standards, see Language Documentation Syntax Note= s.

### int_value

Optional Integer literal that is used to generate random numbers. Use of= a seed value ensures consistency of output between job executions.

• Literal numeric values should not be quoted. Quoted values are tr= eated as strings.
• Multiple columns and wildcards are not supported.

Usage Notes:

Required? Data Type Example Value
No Integer literal `14 `

## Examples=

### Example - Random values

In the following example, the `random` column is generat= ed by the `RAND` function:

=20

derive type:single value:RAND() as:'= random'

source random
A

`0.516845703365675`

B

```0.7111873630= 0207```

C

```0.7586860660= 27118```

D

```0.6401462557= 91255```

### Example - Type check fun= ctions

The `RAND` function is typically used to introduce = randomness of some kind in your data. In the following example, it is used = to perform sampling within your wider dataset.

Tip: Keep in mind that for larger datasets the applicat= ion displays only a sample of them. This method of randomization is applied= to the full dataset during job execution.

Source:

You want to extract a random sample of 20% of your set of orders for fur= ther study:

OrderId Qty ProdId
1001 30 Widgets
1002 10 Big Widgets
1003 5 Big Widgets
1004 40 Widgets
1005 80 Tiny Widgets
1006 20 Widgets
1007 100 Tiny Widgets

Transform:

You can use the following transform to generate a random integer from on= e to 10:

=20

derive type:single value:round(RAND(= ) * 10) as:'random'

You can now use the following transform to keep only the rows that conta= in random values that are in the top 20%, where the value is `9 or 10:`

```=20 keep row:(random > 8) Results: NOTE: Since the results are randomized, your results mi= ght vary. OrderId Qty ProdId random 1005 80 Tiny Widgets 9 1007 100 Tiny Widgets 10 =20 See Also:=20 =20 =20 =20 Page:= =20 =20 =20 Other Functions<= /a>=20 =20 =20 =20 Page:= =20 =20 =20 PI Function=20 =20 =20 =20 Page:= =20 =20 =20 COALESCE Funct= ion=20 =20 =20 =20 Page:= =20 =20 =20 IPFROMINT Fun= ction=20 =20 =20 =20 Page:= =20 =20 =20 URLPARAMS Fun= ction=20 =20 =20 =20 Page:= =20 =20 =20 HOST Function= =20 =20 =20 =20 Page:= =20 =20 =20 DOMAIN Function<= /a>=20 =20 =20 =20 Page:= =20 =20 =20 IPTOINT Functio= n=20 =20 =20 =20 Page:= =20 =20 =20 SUFFIX Function<= /a>=20 =20 =20 =20 Page:= =20 =20 =20 SUBDOMAIN Fun= ction=20 =20 =20 =20 Page:= =20 =20 =20 RANDBETWEEN= Function=20 =20 =20 =20 Page:= =20 =20 =20 RAND Function= =20 =20 =20 =20 Page:= =20 =20 =20 RANGE Function=20 =20 =20 =20 Page:= =20 =20 =20 CASE Function= =20 =20 =20 =20 Page:= =20 =20 =20 SOURCER= OWNUMBER Function=20 =20 =20 =20 =20   ```
``` ------=_Part_32592_1272913116.1606490658250-- ```