Comment on page
Table.TransformRows
Transforms the rows of the table using the specified transform function.
function (table
as table,transform
as function) as list
Creates a table from
table
by applying the transform
operation to the rows. If the return type of the transform
function is specified, then the result will be a table with that row type. In all other cases, the result of this function will be a list with an item type of the return type of the transform function.Table.Transformation
Transform the rows into a list of numbers from the table
({[A = 1], [A = 2], [A = 3], [A = 4], [A = 5]})
.Table.TransformRows(Table.FromRecords({[a = 1], [a = 2], [a = 3], [a = 4], [a = 5]}), each [a])
{1, 2, 3, 4, 5}
Transform the rows in column [A] into text values in a column [B] from the table
({[A = 1], [A = 2], [A = 3], [A = 4], [A = 5])
.Table.TransformRows(Table.FromRecords({[a = 1], [a = 2], [a = 3], [a = 4], [a = 5]}), (row) as record => [B = Number.ToText(row[a])])
{ [ B = "1" ], [ B = "2" ], [ B = "3" ], [ B = "4" ], [ B = "5" ] }
Last modified 5yr ago