Table.AddIndexColumn
Appends a column with explicit position values.
function (table
as table,newColumnName
as text, optionalinitialValue
as nullable any, optionalincrement
as nullable any) as table
Appends a column named
newColumnName
to the table
with explicit position values. An optional value, initialValue
, the initial index value. An optional value, increment
, specifies how much to increment each index value.Table.Transformation
Add an index column named "Index" to the table.
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")
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567", Index=0],[CustomerID=2,Name="Jim",Phone="987-6543", Index=1],[CustomerID=3,Name="Paul",Phone="543-7890", Index=2],[CustomerID=4,Name="Ringo",Phone="232-1550", Index=3]})
Add an index column named "index", starting at value 10 and incrementing by 5, to the table.
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", 10, 5)
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567", Index=10],[CustomerID=2,Name="Jim",Phone="987-6543",Index=15],[CustomerID=3,Name="Paul",Phone="543-7890",Index=20],[CustomerID=4,Name="Ringo",Phone="232-1550",Index=25]})
Last modified 4yr ago