Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.PromoteHeaders

Owen Duncan|Last Updated: 4/19/2018

Table.PromoteHeaders(table as table, optional options as nullable record) as table

About

Promotes the first row of values as the new column headers (i.e. column names). By default, only text or number values are promoted to headers. Valid options: PromoteAllScalars : If set to true, all the scalar values in the first row are promoted to headers using the Culture, if specified (or current document locale). For values that cannot be converted to text, a default column name will be used. Culture : A culture name specifying the culture for the data.

Example 1

Promote the first row of values in the table.

Table.PromoteHeaders(Table.FromRecords({[Column1 = "CustomerID", Column2 = "Name", Column3 = #date(1980,1,1)], [Column1 = 1, Column2 = "Bob", Column3 = #date(1980,1,1)]}))

CustomerIDNameColumn3
1Bob1/1/1980 12:00:00 AM

Example 2

Promote all the scalars in the first row of the table to headers.

Table.PromoteHeaders(Table.FromRecords({[Rank = 1, Name = "Name", Date = #date(1980,1,1)],[Rank = 1, Name = "Bob", Date = #date(1980,1,1)]}), [PromoteAllScalars = true, Culture = "en-US"])

1Name1/1/1980
1Bob1/1/1980 12:00:00 AM
© 2018 Microsoft