I can help with that, Abhishek! ADF doesn't have a built-in unzip activity, but you can combine the Copy Activity and Data Flow to achieve this. Here's a general approach:
- Use Copy Activity to unzip the folder and iterate over each CSV file.
- Inside a loop (ForEach Activity), use Data Flow to:
- Read the first line using a Data Flow source.
Use a conditional split based on the presence of "LOCATION".
Route data to appropriate sink tables (one for "LOCATION", one for others).
For reference, to find out the cost of getting a composite door fitted in the UK, you can search online for how much is a composite door fitted UK?