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"]})