Is it possible to delete certain file types using ADF Delete step?

Question

Hello Community, I have a task that involves unzipping a file and only keeping the .json files from it. The other files that come with the zip are not needed. I use a copy activity to unzip the file and move it to another location, but I want to delete the other file types from the sink. For example, after unzipping I get these files

• .json
• .client
• .session
• .xml

How can I remove the non-.json files from the sink after the copy activity is done? Any better way to do the job?

I appreciate any suggestions.

Answer 1

You can use Delete activity by leveraging wildcard path :

Since 1 file type can be passed at a time, you can create a parameter with all wildcard values semicolon seperated like .xml;.csv and use foreach activity with expression as split(parameter,';') and iterate the wildcard in Delete activity