question

RiktaLaskar-7038 avatar image
0 Votes"
RiktaLaskar-7038 asked ·

Need to add header and trailer record in a csv file - Azure Data factory

Hi All,

I need to implement below logic in my project using Azure Data Factory where we are transferring a csv file from source to destination with some transformation in the file.

Input file contains below data :
111|101|2019-02-04 21:04:57
222|202|2019-02-04 21:33:54
333|202|2019-02-04 20:23:55

Expected Output :
H|TestFile|currentDateTime------------ Need to add this header record.
111|101|2019-02-04 21:04:57
222|202|2019-02-04 21:33:54
333|202|2019-02-04 20:23:55
T|3-------------------------------------- T is static value. Need to add total number of records here.

Can someone please help with this

azure-data-factory
· 4
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RiktaLaskar-7038,

Welcome to Microsoft Q&A forum and thanks for your query.

In order to add the header record you can follow solution proposed in this thread - Azure Data Factory adding header to csv files in Pipeline
I am trying to implement a solution to generate trailer record using Mapping data flow. I will get back to you as soon as I have it ready.

Thank you for your patience.


1 Vote 1 ·

Thanks alot Kranthi. I will try this out.

0 Votes 0 ·

Hi @RiktaLaskar-7038 ,

Just checking to see if the above workaround was helpful to achieve your requirement. I tried for the trailer record but wasn't successful yet.

Let me know if you have any further query.

Thanks

0 Votes 0 ·

Hi @RiktaLaskar-7038 ,

We still have not heard back from you. Just wanted to check if you still need assistance on this query.

Thank you

0 Votes 0 ·

0 Answers