Avoid Helper Queries

[julrua]

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 advance. 

[Hammerschmidt]

Hi @Vera_33 

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 🙂

[edhans]

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.

[Vera_33 · Accepted solution]

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

[ronaldbalza2023]

Hi @Vera_33 I had the same problem with @julrua and did your recommended action to no avail. The custom column was showing an error. Is there any other way to solve this? Thanks 🙂

[Vera_33]

Hi @ronaldbalza2023 

what kind of error you came across? what type of files in the folder you wanted to combine? with the same header?