Changing column header for report build on a snowflake view , using direct query

[mpk]

Hi All, 

I am connecting snowflke view to create a report. I have almost 100 + column with header name like "TEXT_TEXT1" . I need to change header to proper case and removing _ to " Text Text1" column headers. Us there any quick way to do this using functions. 

I am trying to use functions but no luck as this is a view not a table. 

Can I do this using direct query connection or have to use "import " connection ? Please help 

[Fowmy · Accepted solution]

@mpk 

You can simply do it in Power Query in 2 steps:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NY3JDQAxCAN74Z1HAuFILVH6b2MxaD8ja4TNvSRGg3Yk9CRM6I20DrsSayeirUtmRyEKUZZhZWIBia2sVQ92w+psW5P8j4f3guIC4NMv3/sA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [TEXT_TEXT1 = _t, TEXT_TEXT2 = _t, TEXT_TEXT3 = _t, TEXT_TEXT4 = _t]),
    Replace_ = Table.TransformColumnNames(Source, each Text.Replace(_, "_", " ")),
    PropperCase = Table.TransformColumnNames(Replace_, each Text.Proper(_))
in
    PropperCase

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[mpk]

thank you 🙂