Record.ToTable
Record.ToTable(record as record) as table
Returns a table containing the columns Name
and Value
with a row for each field in record
.
Return the table from the record.
Usage
Record.ToTable([OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0])
Output
Table.FromRecords({
[Name = "OrderID", Value = 1],
[Name = "CustomerID", Value = 1],
[Name = "Item", Value = "Fishing rod"],
[Name = "Price", Value = 100]
})