CODEWITHSUNDEEP
azureazure-data-factory
SHIBASHISH TRIPATHY
SHIBASHISH TRIPATHY

Reputation: 91

FIle format in azure data factory

I have multiple format files in a blob storage ,how to check format of only csv files and move that into another folder in azure data factory

Upvotes: 0

Views: 793

Answers (1)

Joel Cochran
Joel Cochran

Reputation: 7748

Use the GetMetadata activity to list the files. Be sure to add the "ChildItems" property: enter image description here

Next use a Filter activity to only process the items that match your criteria: enter image description here

NOTE: this example only processes a) files [ignores subfolders] that b) name starts with "scoring-" and c) ends in ".csv".

Now you can perform the move inside the a ForEach over the filtered list: enter image description here

Upvotes: 1

Related Questions