Modify Whole Table Using Table.TransformColumns() with Default Transformation
#powerquery #power_query
Syntax to Transform Whole Table:
Table.TransformColumns (table, {}, transformation)
= Table.TransformColumns(T1,{}, Text.Upper)
or
= Table.TransformColumns(T1,{}, each Text.Upper(_))
Advanced Editor:
let
Source = null,
T1 = #table({"C1", "C2", "C3", "C4", "C5", "C6", "C7", "C8", "C9", "C10"},{{"marquis", "oscar", "jake", "lester", "paul", "brady", "loyd", "trenton", "erich", "ian"}, {"jacques", "jerald", "lenard", "rigoberto", "aaron", "hung", "marcelino", "samuel", "ramon", "bennie"}, {"heriberto", "wilmer", "brant", "mariano", "ezra", "randal", "graham", "joey", "leslie", "greg"}, {"johnny", "kory", "todd", "aron", "clement", "christopher", "dominique", "damian", "manuel", "refugio"}, {"melvin", "clint", "federico", "corey", "martin", "rupert", "neal", "horace", "emilio", "thanh"}, {"beau", "dallas", "jimmy", "nick", "garrett", "russ", "ferdinand", "dick", "eddy", "ronny"}, {"ava", "emily", "nia", "lucas", "amelia", "emma", "mia", "olivia", "isabella", "charlotte"}}),
Custom1 = Table.TransformColumns(T1,{}, each Text.Upper(_))
in
Custom1
Lone Harvest by Kevin MacLeod is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/...
Source: http://incompetech.com/music/royalty-...
Artist: http://incompetech.com/