Forum Discussion
How combine multiple files from folder NO table
Hi all,
I have troubles with read files from a folder and to combine.
in the folder are files with tables but also files without tables.
This is the error i alway`s have.
What can i do so the data is correct loaded?
and after it should be like this :
Do not forget that the most left is 0, then 1. So you might have to change the number if your data are not on the most left sheet of your files.
You might have to add a step to promote headers but not always the case. Just check if your headers are in place otherwise add a step after Navigate to promote headers.
Tell us if it works...
8 Replies
Hi,
In your M code (Advanced editor, Power Query), you change just a little part of the code to "call" the sheet by its order number and not its name. So it won't be a problem even if your sheets in your files and in your folder have not the same name but they must be at the same place (in the same order).
Select the query called "transform the sample file" (not the function with fx)
and edit the M code via Advanced Editor.Change the inside of {...} :
Source{[Item="Extract01",Kind="Sheet"]}[Data]Into :
Source{0}[Data]It should do the trick, let us know...
Frixel I know what the fix is but hard to explain, can you send pbix file with two sample files one with table and one without table and I will put together the solution.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
