Forum Discussion

julrua's avatar
julrua
Frequent Visitor
5 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

     

     

     

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

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.