I have used one excell file to transform data, I now want to apply this to a folder with similar files. How can I use this file that is already set up to transform the data in the rest of the files that are in the folder i want to upload?
I have used one excell file to transform data, I now want to apply this to a folder with similar files. How can I use this file that is already set up to transform the data in the rest of the files that are in the folder i want to upload?
Convert your existing query as a custom function. It should start with something like:

In a blank query use function Folder.Files to get a table with the files in your folder
Add a custom column to invoke your custom function, passing the [Content] field as parameter to the function
You can find an example in Combine All or Selected Excel Sheets or Tables in Folders
@VANWIJKANSIE-0636. Well done!!! Thanks for posting back. Take care...
3 people are following this question.