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 .
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
and if the file was in xlsx format , it’s not supported either ?
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
Noted.
Thanks.
If you want to add header , you can try using scripting processor .
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 ?
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.
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 .
Please find attached the pipeline for your case and try it from you and let me know if it helps.
Result based on the input provided bu you. Please change the date format if you need .
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.