How to express "for every"?

[Anonymous]

Hello!

How can I express "for every file in a folder", "for every worksheet in a workbook", "for every for every worksheet in every workbook in a folder"?

I think it's the underscore _each or something, but are there any examples?

Thanks!

[amitchandak]

@Anonymous , In power query we use each as loop with _ as item in loop

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

refer

https://learn.microsoft.com/en-us/answers/questions/261717/power-query-loop-calculation

https://www.youtube.com/watch?v=T1q3BF5_YJ8