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
Hi Anonymous
I have the same problem, however adding the custom column didn't solve the problem.
I leave the folder that I am trying to carry out the queries: https://drive.google.com/drive/u/0/folders/10RNAAKY2IQJbcHzocw58rBHOtNFyqLij
Example of what the reading looks like after adding the custom column:
thank you very much for your attention 🙂