Generate CSV file with Header and footer and in footer show the record count and current date

[snkrvish]

Hi, 

Anyone can help regarding generating below output file.

 input file

 Even I have created below pipeline for it but getting extra comma in a footer section