Forum Discussion

mpk's avatar
mpk
Frequent Visitor
6 years ago
Solved

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

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 

 

 

Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    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

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    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