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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
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

 

 

 

 

ronaldbalza2023's avatar
ronaldbalza2023
Icon for Continued Contributor rankContinued Contributor
4 years ago

Hi Anonymous 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 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ronaldbalza2023 

     

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