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)?
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.
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.
I want to add the first 15 rows above the headers in the output. see the below workflow and sample of the input.
@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
I am attaching the required output.
