Forum Discussion

LP2803's avatar
LP2803
Responsive Resident
5 years ago
Solved

Remove specific text from each column headers

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=1...
Need Help
  • LP2803's avatar
    LP2803
    5 years ago

    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"

amitchandak's avatar
amitchandak
Super User
5 years ago

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

  • LP2803's avatar
    LP2803
    Responsive Resident
    5 years ago

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

    • LP2803's avatar
      LP2803
      Responsive Resident
      5 years ago

      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"