How to write an extra header to an existing csv file.
I hope you mean like adding a new row at the top of the DATATABLE
Hope the below steps would help you resolve this
First let’s read the CSV file with read CSV file activity and get the output as DATATABLE named dt
Now we can add a row to the top of the
Refer this thread
How to get the last Wednesday of each month - #2 by Anthony_Humphries
3 then write back to a CSV file with write CSV activity
I am trying to read csv, but its failing as there is an extra cell value(in one of the row) than the columns number.
ie, column numbers = 9
Row 4 column numbers = 10(extra 1 cell value)
So I am trying to add a column header so that the read csv dont fail.
I think it is more probably that you have a comma in the middle of a field value or csv is malformed.
In those cases it is convenient to process csv by reading it as a text file and parsing line by line in order to determine which lines are correct and if you can do something about if it is not right