The headers

[Abdelrahmanmahdy]

Hi,

I have to remove the first 15 lines from the csv file input data to work with it.  I want to add these lines to the output excel file as the headers.

How can I do it ( the second part)?

[Luke_C]

Hi @Abdelrahmanmahdy 

Some example would be helpful, but to start you could use a sample tool to isolate the first 15 records into one data stream, and then a second sample tool connected to the input that skips the first 15 records to compose your second stream of data.

[cjaneczko]

Add a Record ID tool at the start of the workflow with a Filter Tool after it. Anything less than or Equal to 15 goes on the True side anything Greater than 15 goes on the False side. Then add a Union tool to the end of the workflow to add the 15 records back at the top of the output. 

[Abdelrahmanmahdy]

I want to add the first 15 rows above the headers in the output. see the below workflow and sample of the input.

[geraldo]

@Abdelrahmanmahdy 

You can read the file with only the required 14 lines

and generate as rows of data

I didn't understand how you want a header to come out on top of the other data

[Abdelrahmanmahdy]

I am attaching the required output.