跳至主要内容

Record.RenameFields

以 { old, new } 的格式套用清單中的重新命名。

Syntax​

Record.RenameFields(
    record as record,
    renames as list,
    optional missingField as MissingField.Type
) as record

Remarks​

將輸入 record 中的欄位重新命名為清單 renames 中指定的新欄位名稱之後，傳回記錄。如果有多個重新命名，可能會使用巢狀清單 ({ {old1, new1}，{old2, new2} })。

Examples​

Example #1​

將記錄中的 "UnitPrice" 欄位重新命名為 "Price"。

Record.RenameFields(
    [OrderID = 1, CustomerID = 1, Item = "Fishing rod", UnitPrice = 100.0],
    {"UnitPrice", "Price"}
)

Result:

[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]

Example #2​

將記錄中的 "UnitPrice" 欄位重新命名為 "Price", 並將 "OrderNum" 重新命名為 "OrderID"。

Record.RenameFields(
    [OrderNum = 1, CustomerID = 1, Item = "Fishing rod", UnitPrice = 100.0],
    {
        {"UnitPrice", "Price"},
        {"OrderNum", "OrderID"}
    }
)

Result:

[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]

Category​

Record.Transformations