Table.TransformColumns

Syntax

Table.TransformColumns(table as table, transformOperations as list, optional defaultTransformation as nullable function, optional missingField as nullable number) as table

Description

Returns a table from the input table by applying the transform operation to the column specified in the parameter transformOperations (where format is { column name, transformation }). If the column doesn’t exist, an exception is thrown unless the optional parameter defaultTransformation specifies an alternative (eg. MissingField.UseNull or MissingField.Ignore).

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Table Functions / Table.TransformColumns