Categories
Extra Column in CSV Export
Greetings Community, I've been trying to export this Report into CSV Format:
As you can see there are only 4 Columns in OAC Workbook, but this is what CSV looks like:
So how exactly Transaction ID showed up? Just FYI, I've tried to add Sum Aggregation and even tried removing it, doesn't help much.
Interestingly it doesn't happen when I do Excel Export.
Data is coming from NetSuite via SQL View from Oracle Database Actions.
Please let us know if anybody can decipher this.
Thank You ☺
Best Answer
-
Hi,
I would first check what query is executed to render that visualization.
The CSV export historically (in "classic") has always been the export of the query result itself, without any rendering or formatting. If, for any reason, your visualization does query 5 columns, and the names matches those of the CSV, we can say that the same behavior happen in DV, and therefore the CSV you got is not wrong.
Then, why there are 5 columns in the query while only 4 are visible, I would say it depends on the details of your source and/or workbook.
You can also check if there isn't a "ghost" reference to TRANSACTION ID left somewhere in the JSON code defining the workbook and/or the visualization.
1
Answers
-
Hi,
Similar to @Gianni Ceresa's answer, historically, the CSV is exporting the query result. If you want the visual result exported, then you need to export in XLSX. I just made the test, and it's exactly the same as you. The hidden column is appearing in CSV but not in a "Formatted" excel file like XLSX.
0
