Power Query
Search…
published
Table
Table.TransformRows

Table.TransformRows

Transforms the rows of the table using the specified transform function.
function (table as table, transform as function) as list

Description

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.

Category

Table.Transformation

Examples

Transform the rows into a list of numbers from the table ({[A = 1], [A = 2], [A = 3], [A = 4], [A = 5]}).
1
Table.TransformRows(Table.FromRecords({[a = 1], [a = 2], [a = 3], [a = 4], [a = 5]}), each [a])
Copied!
{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]).
1
Table.TransformRows(Table.FromRecords({[a = 1], [a = 2], [a = 3], [a = 4], [a = 5]}), (row) as record => [B = Number.ToText(row[a])])
Copied!
{ [ B = "1" ], [ B = "2" ], [ B = "3" ], [ B = "4" ], [ B = "5" ] }