Skip to main content
Submitted

Excel columns original order

  • July 11, 2018
  • 1 reply
  • 0 views

Forum|alt.badge.img

When I import from an Excel file, why does TX automatically sort the column names alphabetically? Having the option to import the columns in their original order would be great. Sometimes there is a rationale to the column ordering.

 

 

1 reply

Forum|alt.badge.img

This is especially useful for sheets that have duplicate column names with different meanings. In these cases the column order has additional meaning. Consider the following typical finance sheet:

2017A>J F M A M J J S O N D 2018B> J F M A M J J S O N D

Only if the columns are in the original order, can you know for which year the month column is.