Forum Discussion
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" c...
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 🙂
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 🙂
thank you 🙂
