Forum Discussion
Power Query Editor Transform file helper Query folders
I have lots of files I have created from folders and now I have lots of these cluttering up power Query Editor
I really dont like it. Is there any way I can actually get rid of all these and...
These are meant for beginners. Once you checked how they work you will realize how inefficient they are, for example they use the "first" file as the blueprint for the column list of all the files - which may not be what you want. The also read that "first" file twice, for no good reason.
Replace them with your own, more streamlined code (via Table.AddColumn and Table.ExpandTableColumn) and then you can delete the groups.
I wouldnt know how to do this. is there any documentation or anything I can use to replace the code and then get rid of these?