ExtraValues.Type specifies the expected action for extra values in a row that contains columns more than expected.
Enumeration Options
Enumerations simplify the process of selecting options within a function. To specify the ExtraValues.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).
| Argument | Value | Description |
|---|---|---|
| ExtraValues.List | 0 | If the splitter function returns more columns than the table expects, they should be collected into a list. |
| ExtraValues.Error | 1 | If the splitter function returns more columns than the table expects, an error should be raised. |
| ExtraValues.Ignore | 2 | If the splitter function returns more columns than the table expects, they should be ignored. |
Applies to
Here’s a list of functions that work with ExtraValues.Type:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy