Table.ReplaceValue – แทนที่ค่าในตารางตามเงื่อนไข

let
    Sales = Table.FromRecords({
        [Product = "Laptop", Status = "approved"],
        [Product = "Mouse", Status = "approved"],
        [Product = "Keyboard", Status = "pending"]
    }),
    Replaced = Table.ReplaceValue(Sales, "approved", "Confirmed", Replacer.ReplaceValue, {"Status"})
in
    Replaced

let
    Data = Table.FromRecords({
        [Name = "John_Smith"],
        [Name = "Jane_Doe"],
        [Name = "Bob_Johnson"]
    }),
    Replaced = Table.ReplaceValue(Data, "_", " ", Replacer.ReplaceText, {"Name"})
in
    Replaced

let
    Orders = Table.FromRecords({
        [Customer = "Alice", Country = "US", Status = "New"],
        [Customer = "Bob", Country = "UK", Status = "New"],
        [Customer = "Charlie", Country = "US", Status = "New"]
    }),
    Replaced = Table.ReplaceValue(
        Orders,
        each if [Country] = "US" then [Status] else false,
        "US-New",
        Replacer.ReplaceValue,
        {"Status"}
    )
in
    Replaced

let
    Names = Table.FromRecords({
        [OriginalName = "alice"],
        [OriginalName = "bob"],
        [OriginalName = "charlie"]
    }),
    Replaced = Table.ReplaceValue(
        Names,
        each [OriginalName],
        each Text.Proper([OriginalName]),
        Replacer.ReplaceValue,
        {"OriginalName"}
    )
in
    Replaced

let
    Codes = Table.FromRecords({
        [ItemCode = "SKU-12345"],
        [ItemCode = "SKU-67890"],
        [ItemCode = "SKU-54321"]
    }),
    Replaced = Table.ReplaceValue(Codes, "SKU-", "", Replacer.ReplaceText, {"ItemCode"})
in
    Replaced

let
    Data = Table.FromRecords({
        [FirstName = "N/A", LastName = "N/A", Status = "Active"],
        [FirstName = "John", LastName = "Doe", Status = "Active"],
        [FirstName = "N/A", LastName = "Smith", Status = "Inactive"]
    }),
    Replaced = Table.ReplaceValue(Data, "N/A", null, Replacer.ReplaceValue, {"FirstName", "LastName"})
in
    Replaced