How do I looping different information CSV files b...

Anonymous · ‎09-29-2023

Hi Lads,

I've 7 different information CSV files in Single folder. How do i looping through these files by using Power Query. How do I get separate data from those files. If I do this some parameterization to get one file data then How I need to do this parameterization for remaining files by using power query. Please do the needful lads, Thanks ....I'm added the table info

lbendlin · ‎10-01-2023

Do these files have the same structure? Write a custom function that processes the first file, and then adapt it to process all files. Finally combine the results. Kinda like "Combine binaries" works but without all the gruft.

Anonymous · ‎10-02-2023

No @lbendlin These files are not have same structure . That is my problem arriving in my end . if i'm combining all these files each file have separate details of each granular level. I want retrieve all these files information separately by tables with some automatiuon task of power query.

lbendlin · ‎10-02-2023

If they don't have the same structure then you need to run separate Power Query queries. You can reuse the folder access part but after that each query will be different.