0

I have to pick a csv file from a filesystem folder and put it into a storage account folder. I need to add the name of the column to the csv file when copying it into the storage because after I must use anohter standard pipeline which need the columnname in the file. Is it possible to do it in datafactory or i should try to use other services?

Improve this question
6
  • Do you mean you want add one header as a column in csv file? In Azure Data Factory, can you try additional column in Copy Activity? Commented Nov 30, 2020 at 1:31
  • I mean I don't have the headers in my source file and i want to add it. Sorry if I explained myself badly. Commented Nov 30, 2020 at 8:13
  • Where are the headers from? Commented Nov 30, 2020 at 8:17
  • I want to add them, in the source folder i have a csv file like: 3323423;gigio;cefefee;2222 2222222;pippo;cccccc;3333 I want to put in my sink folder the same file but with a header, then I want to add a row at the top: id;name;piva;codice 3323423;gigio;cefefee;2222 2222222;pippo;cccccc;3333 An use that first row as header in another pipeline to laod the file into an sql db. I want to add the headers, there is not one . Commented Dec 1, 2020 at 10:25
  • I think you should use dataflow to merge these csv files(one with headers and others with content). Commented Dec 3, 2020 at 7:46

1 Answer 1

Reset to default
1

In ADF, you can add a column in Copy Activity via additional column.

You can key in the name and value, the result is as follows: enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.