= let
    Data = Table.FromRecords({
        [ID = "1", Amount = 1000, Active = "true"],
        [ID = "2", Amount = 2500, Active = "false"],
        [ID = "3", Amount = 1500, Active = "true"]
    }),
    Transformed = Table.TransformColumns(Data, {
        {"ID", Number.FromText, type number},
        {"Amount", Number.FromText, type number},
        {"Active", Logical.FromText, type logical}
    })
in
    Transformed

= let
    Sales = Table.FromRecords({
        [Product = "Pen", Price = 10, Quantity = 100],
        [Product = "Pencil", Price = 5, Quantity = 200],
        [Product = "Eraser", Price = 2, Quantity = 150]
    }),
    Transformed = Table.TransformColumns(Sales, {
        {"Product", Text.Upper, type text},
        {"Price", each _ * 1.1, type number},
        {"Quantity", each _ * 0.95, type number}
    })
in
    Transformed

= let
    Data = Table.FromRecords({
        [Name = "John", Surname = "Doe", Code = "ABC"],
        [Name = "Jane", Surname = "Smith", Code = "XYZ"]
    }),
    Transformed = Table.TransformColumns(
        Data,
        {{"Code", Text.Lower, type text}},
        Text.Upper  // defaultTransformation สำหรับคอลัมน์อื่น
    )
in
    Transformed

= let
    Data = Table.FromRecords({
        [ID = 1, Name = "Alice"],
        [ID = 2, Name = "Bob"]
    }),
    Transformed = Table.TransformColumns(
        Data,
        {
            {"ID", Number.From, type number},
            {"Name", Text.Upper, type text},
            {"Email", Text.Upper, type text}  // คอลัมน์ที่ไม่มีในข้อมูล
        },
        null,
        MissingField.UseNull
    )
in
    Transformed

= let
    Inventory = Table.FromRecords({
        [SKU = "A001", Stock = "100", Category = "Electronics"],
        [SKU = "B002", Stock = "50", Category = "books"],
        [SKU = "C003", Stock = "200", Category = "OFFICE"]
    }),
    Transformed = Table.TransformColumns(Inventory, {
        {"SKU", Text.Upper, type text},
        {"Stock", each Number.FromText(_) * 1.05, type number},
        {"Category", Text.Proper, type text}
    })
in
    Transformed