I'm confused why Tableau automatically sorts column names of TDE. I have a datasource (SQL) and I sorted 141 columns based on business user requirements. Now I have to do extract of my SQL datasource to create TWBX. However, after the extract, tableau just sorted the column names in ascending A-Z order.
Is there any way to keep the order of column names from datasource to TDE?
EDIT: Please go to this thread with similar idea.
Thanks,
Mark Ruiz
Thanks Khalid for the straight forward recommendation. However I think the issue goes beyond just by sorting by datasource. I'll give you few examples and the desired output.
As you suggested, we can sort by datasource in "source tab",
We can also sort by datasource in the left most pane.
However, when exporting to excel, it sorts alphabetically A-Z: (Product, Product Line, Product Type) vs the sorting of datasource: (Product Line, Product Type, Product).
Now, when we view the underlying data, we see the issue. Tableau sorts its own way thus the issue in export/copy.
