CODEWITHSUNDEEP
azure-data-factory
Qianru Song
Qianru Song

Reputation: 331

Load multiple xlsx from Blob to ADF

I created a dataset containing all xlsx files (file per country) from Blob.

enter image description here To validate if all countries are loaded to the data flow, I created a sink after loading source data.

In the data preview, there is only one country (I set up debug settings to make sure all data come to be checked by statistics function); From the output (format txt), I view one country, then Blanks which are separated by comma, then some countries, then blanks.

I reviewed the blogs, and set up a wildcard path which is the same as File Path. The problem is still unsolved.

I appreciate someone providing any insights and comments to fix it.

Upvotes: 0

Views: 695

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

Make sure these .xlsx files have the same schema and sheet name, that's the key. I test and it works. All the files will be loaded.

Here are my example excel files A.xlsx and B.xlsx, I put them in the one container: enter image description here enter image description here

With Copy data tool, set the container as path and all the files are loaded correctly: enter image description here

Sink settings: enter image description here

And here's the copy active overview: enter image description here

Please note:

  1. use Merge files in Sink Copy behavior.
  2. set the delimiter which data not contains.

Output file AB.txt: enter image description here

HTH.

Upvotes: 1

Related Questions