Copy Info From Header To all Rows in CSV

Hi,

I am trying to import a CSV file , in which first row in each file contains information about the file ( where it came from etc ) and next row onwards are records.

[HEADER ROW] HD;1;2;BGRCM;AFGAW;04682;20160831061512;+0300;20160831053847;+0200;3;10;;;;BGN;;3;5;;20160831061512;+0300;[HEADER ROW]

[DATA]
MT;4XXXXXXXX;9XXXXXSSR;357807066041730;1;21;;TEST;;;20160830075130;+0300;0;;2;359898000100;4617306951892;;;;;;;;;;;;
CI;E;;;;;;0;246024;
MT;4XXXXXXXX;9FDFDD;XDSDEA;1;21;;TEST;;;20160830075132;+0300;0;;2;359898000100;4617306951903;;;;;;;;;;;;
CI;E;;;;;;0;246024;
MT;4XXXXXXXX;TEST;357807066041730;1;21;;TEST;;;20160830075136;+0300;0;;2;359898000100;4617306951911;;;;;;;;;;;;
CI;E;;;;;;0;246024;

I want guidance on how to process the header row and include data from header row in all of the rows in the same file.

The problem is that the header row has different fields from the data.

This isn't supported yet but there's an open pull request.

wow - thanks for the quick response , but this sets the header row as column names - but i want to take that info and add it over to every line ( since the header field count and types are different from actual data count / type ).

Any way i can achieve that?

In that case the answer is: This isn't supported yet and there's no open pull request.