How do I looping different information CSV files by Power Query

[Yogitheanalyst]

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]

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.

[Yogitheanalyst]

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]

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.