Table.AddKey

语法

Table.AddKey(table as table, columns as list, isPrimary as logical) as table

关于

将一个键添加到 table，给定的 columns 是定义该键的 table 的列名称的子集，并且 isPrimary 指定该键是否为主键。

示例 1

向包含 { "Id" } 的 { [Id = 1, Name = "Hello There"], [Id = 2, Name = "Good Bye"] } 添加键并使其成为主键。

使用情况

let    tableType = type table [Id = Int32.Type, Name = text],    table = Table.FromRecords({         [Id = 1, Name = "Hello There"],        [Id = 2, Name = "Good Bye"]     }),    resultTable = Table.AddKey(table, { "Id" }, true)in    resultTable

输出

Table.FromRecords({     [Id = 1, Name = "Hello There"],    [Id = 2, Name = "Good Bye"] })