Forum Discussion
Removing sample & transform files from Power Query editor
Hi, Ref. the attached snapshot, I am ending up with a long list of unwanted queries that I do not use at all. I am aware that they are useful for debugging. But I have managed to identify the errors...
Once you understand how to merge files efficiently you don't need any of these queries. What you do need is a list of the columns in your source files. You need to specify that column list during Table.Combine() , and these helper functions do that via reading a sample file twice. To avoid that you use the predefined column list.
Can you please advise (with an example) how to use the' predefined column list'? do you mean I am using an inefficient method of merging the files and that's why I ended up with such a long list of unnecessary queries?