CODEWITHSUNDEEP
azureazure-data-factory
saqibm
saqibm

Reputation: 11

Process excel sheets in datafactory

I m trying to process single excel file with multiple sheets in it thru datafactory but I m not sure how to make process all sheets? I have set this field as parameterized in the dataset but not sure how to provide it with the sheet name enter image description here

Upvotes: 1

Views: 445

Answers (1)

Steve Johnson
Steve Johnson

Reputation: 8690

You can create an array variable filled with your sheet name, then use For Each activity to loop it.

1.Create a variable enter image description here

2.Setting of For Each activity enter image description here

3.Setting of dataset enter image description here

Upvotes: 2

Related Questions