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


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

Power Query M Functions / Table Functions / Table.TransformColumns