ExpandMultiValueLimit Parameter (Connect-Workday Cmdlet)
The maximum number of output rows that can be expanded from a single input row.
Syntax
Connect-Workday -ExpandMultiValueLimit int
Data Type
int
Default Value
500
Remarks
When using ExpandMultiValues, the cmdlet can generate multiple output rows for each input row from Workday. Each multi-value column included in the query increases the number of output rows exponentially. For example, if a table has five array columns and has one row has three values for each, then rows are generated in this pattern:
| Number of Array Columns Selected | Number of Output Rows |
| 0 | 1 |
| 1 | 3 |
| 2 | 9 |
| 3 | 27 |
| 4 | 81 |
| 5 | 243 |
Realistic queries can output thousands of rows which can be expanded into hundreds of thousands of output rows. Generating these rows reduces the cmdlet's performance and can potentially cause the cmdlet to run out of memory.
To avoid this, the cmdlet counts the number of output rows before actually generating them. If any input row would generate more rows than the ExpandMultiValueLimit, the cmdlet reports an error instead. When this happens you should carefully evaluate the query and remove any array columns that are not required. Only increase this limit if there is no way to simplify your query.