How can i replace the value of one column with another column in query editor

[nandukrishnavs]

I have Table with two column. first column is "Indicator" and second column is "Sub-Indicator". I want to replace all the indicator value with coresponding Sub-Indicator value. 

[v-yuezhe-msft · Accepted solution]

@nandukrishnavs,

Add a new blank query in Power BI Desktop, then paste the following code into Advanced Editor of the blank query. Please note that the highlighted code do the replace value job.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUUpRitWJVnICslLBLGcgK00pNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Indicator = _t, #"Sub-Indicator" = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,each [Indicator],each [#"Sub-Indicator"],Replacer.ReplaceText,{"Indicator"})
in
    #"Replaced Value"

Another method is to duplicate the sub-indicator column, and then remove the Indicator column.

Regards,
Lydia

[nandukrishnavs]

I tried this formula 

Table.ReplaceValue(#"Renamed Columns4", each [Indicator],"", Replacer.ReplaceValue,{"Sub-Indicator"})

But few Indicator values remains the same.