I am trying to export the worksheet in Tableau to an excel CSV format through an automated program. However, though the data is transported correctly, the rows and columns surprisingly interchange in the excel. I want excel output to be exactly getting displayed like in Tableau without interchanging rows and columns. Can anyone tell me some way out.
I've run into this before and I think the root cause is that it exports by alphanumeric order. So in order to get it to work, I had to name the fields within the workbook prefixed by "_field1_", "_field2_", "_field3_", etc.