@Anandhakumar Cholendran - Thanks for the question and using MS Q&A platform.Here are the steps to add headers to txt file using ADF Dataflow:
Step1: Create a data flow and add a source and point to the text file located in the storage account and make sure to the ignore selecting First row as header
option.
Step2: Repeat the same for adding the sink where you want the output to be stored.
Step3: Select Sink and go to mapping option and I would suggest you disable Auto mapping in Sink's Mapping tab and then name Output columns as column header name as per your requirement.
Step4: Click on datapreview option to shows the data with headers to output file.
Step5: Add a Data flow activity and attach the dataflow created and run.
Hope this helps. Do let us know if you have any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.