ExpandMultiValueLimit Parameter (Connect-Workday Cmdlet)
The maximum number of output rows that may be expanded from a single input row.
Syntax
Connect-Workday -ExpandMultiValueLimit int
Data Type
int
Default Value
500
Remarks
When using ExpandMultiValues, the 本製品 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 本製品's performance and can potentially cause the 本製品 to run out of memory.
To avoid this, the 本製品 counts the number of output rows before actually generating them. If any input row would generate more rows than the ExpandMultiValueLimit, the 本製品 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.