Extra Column in CSV Export

Question

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 ☺

Gianni Ceresa · Accepted 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.