Hi saffron0103 ,
Congratulations!!
I too would like to know how to achieve that...
I wish I could do recursion on DataFactory, but...
If you use LogicApps, this may be a good reference.
- https://docs.microsoft.com/en-us/answers/questions/32165/logicapp-to-loop-through-folder-and-subfolders-in.html
Alternatively, I think it could be done with a combination of direct coding activities such as Azure Functions and Azure DataBricks.
If I implement it, I will share it with you.
- https://docs.microsoft.com/en-us/azure/data-factory/control-flow-azure-function-activity
- https://docs.microsoft.com/en-us/azure/data-factory/transform-data-databricks-notebook
Regards,
Microsoft