CreateMatrix
The CreateMatrix() function generates a random block of test data.
Syntax
CreateMatrix (Rows, Columns, Data Generation Pattern, Format, Additional)
| Rows | The number of rows to generate |
| Columns | The number of columns to generate |
| Data Generation Pattern | |
| Format | |
| Additional |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Example 1. Generate a simple block of data
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example 1. Generate a simple block of data
| Create Matrix function |
| =CreateMatrix(4,5) |
| Output | ||||
| 560.163891 | 477.993537 | 258.680476 | 622.324729 | 222.263602 |
| 529.537509 | 720.732615 | 484.578862 | 726.510174 | 930.972459 |
| 641.240762 | 67.2087442 | 291.132885 | 712.991375 | 943.852175 |
| 364.534978 | 497.008137 | 949.179182 | 852.876248 | 796.3235 |