'ADF - Dynamic Sheet
i am trying to Append Datasets from Excel files on ADF. In one file my tab name is "CD" and in other it is "LD". I have several files like this with various tab names and same data format that need to be Appended in a single table. How can i do this dynamically on ADF?
Solution 1:[1]
Follow below steps:
- make an excel sheet having names of all the source data sheet names.
- use a lookup activity to fetch all the names of source data from this sheet.
- Parameterize your dataset and use the output of lookup activity as parameters.
- Use a forEach activity and use copy activity inside it for copying your data
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Venkataraman R |