ExtraValues.Type

Updated on

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:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/extravalues-type