Forum Discussion
Solved
Is it possible to Append Query to each Source?
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 t...
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.
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.