Forum Discussion
Import multiple files with multiple sheets from folder
Hi marina_oliveria
It's a bit manual initially but you could:
1. Get data -> From Folder -> browse to the path/file location.
2. Navigation step: choose one sheet ( Jan).
3. Expand out all data.
Similarly, duplicate the previous queries and change the navigation step to the required sheet. OR perform this file from folder step multiple times and select the Navigation sheet ( Feb .. Dec).
Finally, Append all Final Data tables into one master data table.
Please accept this solution if it resolves the query.
Community ChampionCan you provide a couple of those files you are trying to ingest as example? If necessary with dummy data (but the same structure as the original ones). That will help greatly in finding an adequate solution
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |