Forum Discussion
Dynamically return all column names
Hi In power query i have the following which dynamically reads the column names for outputting. Im just wondering if there is a cleaner solution whereby i dont have to transform each column but rath...
I hadn't noticed. Try it this way (or a differente combination of text and number :-)):
#"Changed Type"=Table.TransformColumnTypes(Source, {DynamicNameHeader{0}, type text}& List.Transform(List.Skip(DynamicNameHeader,1), each {_, type number}))
Got it!....If i just remove Columns=18, it works then...thanks for your help
No it dosnt work....i changed it to expect 8 but 18 was sent in source and only 8 displayed. Only works if the source has actually less than the expected number...in this case the expected columns are just blank
Got it!....If i just remove Columns=18, it works then...thanks for your help