Forum Discussion
Solved
Avoid Helper Queries
Dear all, I did the following steps for 4 differents folder: 1- Get data 2- Folder 3- Combine data Can I avoid to have several Helper Queries into Power Query Editor ? Thank you in ...
Hi julrua
You are reading from folders, right? Add a custom column, then use Excel.Workbook or Csv.Document (or anything else, depending on your files in the folder) to avoid help queries, combine the tables in the custom column
Not without 100% manually doing the combine operation yourself with manual code.
Those were introduced about 3 years ago to make the combining of files more robust and flexible. There is a full overview here.