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

Table.AddIndexColumn

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns a table with a new column with a specific name that, for each row, contains an index of the row in the table.

Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
newColumnNameThe name of the new column.
optional initialValueThe initial column index. The default initial index is 0.
optional incrementThe column index increment. The default increment is 1.

Examples

Table.AddIndexColumn(Table.FromRecords(  
  
{  
  
      [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  
  
      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  
  
      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  
  
}  
  
), "Index")  
CustomerIDNamePhoneIndex
1Bob123-45670
2Jim987-65431
3Paul543-78902
4Ringo232-15503
Table.AddIndexColumn(Table.FromRecords(  
  
{  
  
      [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  
  
      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  
  
      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  
  
}  
  
), "Index", 1, 2)  
CustomerIDNamePhoneIndex
1Bob123-45671
2Jim987-65433
3Paul543-78905
4Ringo232-15507
© 2018 Microsoft