Table.TransformColumnTypes
Applies type transformation(s) of the form { column, type } using a specific culture.
function (table
as table,typeTransformations
as list, optionalculture
as nullable any) as table
Returns a table from the input
table
by applying the transform operation to the columns specified in the parameter typeTransformations
(where format is { column name, type name}), using the specified culture in the parameter culture
. If the column doesn't exist, an exception is thrown.Table.Transformation
Transform the number values in column [a] to text values from the table
({[a = 1, b = 2], [a = 3, b = 4]})
.Table.TransformColumnTypes(Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4]}), {"a", type text}, "en-US")
Table.FromRecords({[a = "1", b = 2], [a = "3", b = 4]})
Last modified 4yr ago