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

[Codemunchkin]

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. 

Example:

The column to be renamed is called "Rename", the column to check (condition) for is "Country"

Rename | Country |

   data    |   UK       |

   data2  |   US       |

   data3  |   UK       |

[smpa01 · Accepted solution]

@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]

Thank you so much!!