Forum Discussion
Transforming mulitple sheets in multiple files when using 'Load from folder'
Hello KWilkinson02
Try to do as follows
- Query one Excelfile in order to have the result you want
- Create a new text parameter calles "FileName" with the complete path of your Excel-file
- enter advanced editor and substitute in the first line the path information with your newly created parameter
- right click on the query and select create function. Give it the name "GetData"
- Query your folder
- Add new column invoking your function like GetData([Path]&[Name])
- Combine the new created column to one table
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy801 ,
I have another question. How can I update the query after it is created?
I'm pulling data from Ranges within my data source and I'm finding if I alter a range my amalgamated data isn't updating.
Also if I amend the Query I can see the new data but this doesn't cascade down into the amalgamated data. Equally, if I just make a change to the Query by say removing another column this also doesn't cascade down. Is there some means to update the Function? From the stuff I've read elsewhere, it sounds like it should update automatically...
Ah, got it, I'd missed the 'Load more' option!
Hello KWilkinson02
be carefull about the load-more option because if you really have a lot of files with different column names I'm not hundred percentage sure that this option will check every table. Better check it every now and then
Jimmy
Thanks for the heads up. In this instance I think it's fine because I'm checking specific tables/ranges where I know I've made changes.