Forum Discussion

Codemunchkin's avatar
Codemunchkin
Frequent Visitor
4 years ago
Solved

Renaming column only if another columns' rows contain a certain value

Hi,    I am trying to change a column name based on a condition.   The condition is if another column' rows contain a certain value such as 'UK' then change the column name to the specified name....
Need Help
Show and Tell
  • smpa01's avatar
    smpa01
    4 years ago

    Codemunchkin  you can try this

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkksSTRU0lEqLVaK1YFwjYDcRCS+MZCfnJinFBsLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Country = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Country", type text}}),
    Custom1 = if List.Contains(#"Changed Type"[Country],"us") then Table.RenameColumns(#"Changed Type",{{"Name", "Rename"}}) else #"Changed Type"
in
    Custom1
smpa01's avatar
smpa01
Community Champion
4 years ago

Codemunchkin  you can try this

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkksSTRU0lEqLVaK1YFwjYDcRCS+MZCfnJinFBsLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Country = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Country", type text}}),
    Custom1 = if List.Contains(#"Changed Type"[Country],"us") then Table.RenameColumns(#"Changed Type",{{"Name", "Rename"}}) else #"Changed Type"
in
    Custom1
Codemunchkin's avatar
Codemunchkin
Frequent Visitor
4 years ago

Thank you so much!!