ExtraValues.Type

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).

ArgumentValueDescription
ExtraValues.List0If the splitter function returns more columns than the table expects, they should be collected into a list.
ExtraValues.Error1If the splitter function returns more columns than the table expects, an error should be raised.
ExtraValues.Ignore2If 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:

BI Gorilla Youtube Channel

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/extravalues-type
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.