Remove specific text from each column headers

[LP2803]

Hi Team,

can anyone help me how can i remove some text from the column headers in M Query. 

Below is how my advance editor looks like as of now.

let
Source = Table.Combine({#"59Z]&size=10000", #"59Z]&size=10000 (2)"}),
#"Filtered Rows" = Table.SelectRows(Source, each not Text.Contains([Column1._index], "xyz"))
in
#"Filtered Rows"

[amitchandak]

@LP2803 , column headers should be renamed ? Data you can replace/remove ?

[LP2803]

@amitchandak the column names contains text "column1._source"  which i need to replace with null.

[LP2803 · Accepted solution]

I figured it out 🙂 thank for your help @amitchandak 

let
Source = Table.Combine({#"59Z]&size=10000", #"59Z]&size=10000 (2)"}),
#"Rename all Headers" = Table.TransformColumnNames(Source,each Text.Replace(_,"Column1._source.","")),
#"Filtered Rows" = Table.SelectRows(#"Rename all Headers", each not Text.Contains([Column1._index], "xyz"))
in
#"Filtered Rows"