Is it possible to Append Query to each Source?

[GooseHelpful199]

I have a folder containing numerous Excel files in the same format, which I currently import by selecting Sharepoint Folder, searching up that Folder location, and then Combine/Transforming each of those Excel files. However, I want to add extra rows to each of those source Excel files.

I have a separate table that contain the rows I want to add, but if I append it will simply append to the final result. Is there a way to append or add rows from another query so that they are added to each of the source files?

[lbendlin]

Alternatively, examine the code produced by the sample process, then throw it away and implement your own ingestion steps (including the append)  for each file in your list. That way you also avoid reading the first file twice.

[spinfuzer · Accepted solution]

Edit The Transform Sample File and Append to the Sample File (under helper queries) instead of the main query (which is under other queries).

Editing the Sample File/Query will make changes to each file BEFORE combining.

Changes to the main query applies changes AFTER combining.