Clarification on Adding a New Column ("City") to CSV file Extracted via API in Azure Data Factory
I am currently working on utilizing an API to extract data in CSV format through Azure Data Factory (ADF). I have encountered a requirement to include an additional column named "City" in the output file, even though this column is not present in the API data.
To address this, I am seeking guidance on two aspects: Source Setting in Azure Data Factory: I would appreciate clarification on how to configure the source settings in Azure Data Factory to incorporate the new column "City" during the data extraction process. Specifically, I am interested in understanding any parameters or configurations necessary to achieve this seamlessly.
- Mapping the New Column in Data Flow: Once the data is extracted, I need to map the newly added "City" column within the Azure Data Factory . Could you please provide insights on how to appropriately map this new column, ensuring it aligns with the rest of the data structure?
could you guide me on how to add a new column(city) to an existing CSV file in the blob storage using ADF
Ok, what I understand is, your source is a REST API, and you want to have additional column called City and want to pass value to this additional column dynamically through Params\variable. You can use copy activity and add additional column under source tab, and pass dynamic content as value. Dynamic value can come from a variable or parameter or system variables and functions. Does this make sense to you? Please revert if my understanding is not completely right. HTH.
Sign in to comment