is there a way to write headers first like the ones in yellow rows in the screenshot before adding the needed columns after in a csv file ?
after the 4th row the data should be displayed as a normal csv file, However i cannot figure out how to write the first 3 rows .
Result based on the input provided bu you. Please change the date format if you need .
Please find attached the pipeline for your case and try it from you and let me know if it helps.
I will try to provide the code snippet for that.
Let me clear your need , you need headers columns should be after the data row.
If you can provide me a sample file which you are trying and your expected result then i can help you on that.
Here is the scenario:
The only difference is that i need to write three rows first that are not included in the data ( the first three yellow rows in the attached file) then writing the header row then the actual data as usual .
I will try to provide the code snippet for that.
Let me clear your need , you need headers columns should be after the data row.
If you can provide me a sample file which you are trying and your expected result then i can help you on that.
If you want to add header , you can try using scripting processor .
Can you please provide me with an example on how to add the above headers to a csv/xlsx file ?
If you want to add header , you can try using scripting processor .
Noted.
Thanks.
They are technically the same, at the end our records are a map of key values, so we take the header (first row) as keys and then the subsequent rows as values
and if the file was in xlsx format , it’s not supported either ?
Based on how data is structured in a CSV, we understand headers as the very first row, meaning that it contains the column name.
I don't think we support adding multiple rows as headers. If you are a customer my recommendation will be to open a feature request
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.