Forum Discussion

MarkJF's avatar
MarkJF
Frequent Visitor
9 years ago
Solved

Programmatically change the case of headers (from a csv file)

Hi   I created a detailed report Report with data from csv files, and the Promoted Headers function provided me with headers all in lower case. I now need to change the Source of the files, and th...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Or just change the column headers:

     

    let
    Source = #table(2,{{1,2}}),
    HeadersUpperCase = Table.TransformColumnNames(Source,Text.Upper)
in
    HeadersUpperCase
MarkJF's avatar
MarkJF
Frequent Visitor
9 years ago

Thanks, now I can see the function Table.TransformColumnNames it all makes sense!

 

(I think the transpose method might work as well, but my table has thousands of rows which might be an issue.)

 

regards

 

Mark

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How would you apply to this to all the data vs the headers?  I want it to make all the text in a table uppercase, but the number of columns change / are not consistent.

 

When I try to apply the same concept to the Table.TransformColumns it gives me an "Expression.Error: We cannot convert a value of type Function to type Text."