Table.AddIndexColumn

冬夜先生

发布于 2022-01-04 16:01:16

3790

发布于 2022-01-04 16:01:16

文章被收录于专栏：csicocsico

语法

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

关于

使用显式位置值将名为 newColumnName 的列追加到 table 中。一个初始索引值 initialValue（可选值）。一个可选值 increment，指定每个索引值的增量。

示例 1

将名为“Index”的索引列添加到表。

powerquery-m复制

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

CustomerID	名称	电话	索引
1	Bob	123-4567	0
2	Jim	987-6543	1
3	Paul	543-7890	2
4	Ringo	232-1550	3

示例 2

从值 10 开始、按 5 递增将名为“Index”的索引列添加到表。

powerquery-m复制

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
)