Comment on page
Table.FromList
Converts a list into a table by applying the specified splitting function to each item in the list.
function (list
as list, optionalsplitter
as nullable function, optionalcolumns
as nullable any, optionaldefault
as nullable any, optionalextraValues
as nullable any) as table
Converts a list,
list
into a table by applying the optional splitting function, splitter
, to each item in the list. By default, the list is assumed to be a list of text values that is split by commas. Optional columns
may be the number of columns, a list of columns or a TableType. Optional default
and extraValues
may also be specified.Table.Table construction
Create a table from the list with the column named "Letters" using the default splitter.
Table.FromList({"a", "b", "c", "d"}, null, {"Letters"})
Table.FromRecords({ [ Letters = "a" ], [ Letters = "b" ], [ Letters = "c" ], [ Letters = "d" ] }, { "Letters" })
Create a table from the list using the Record.FieldValues splitter with the resulting table having "CustomerID" and "Name" as column names.
Table.FromList({[CustomerID=1,Name="Bob"],[CustomerID=2,Name="Jim"]} , Record.FieldValues, {"CustomerID", "Name"})
Table.FromRecords({[CustomerID=1,Name="Bob"],[CustomerID=2,Name="Jim"]})
Last modified 5yr ago