Maintain order of columns after a dynamic rename

Question

I am looking to maintain the order of columns after a dynamic rename.  I believe designer thinks the columns are new and throws them to the end of the list.  I need the columns to be in a specific order prior to output.  The columns will not always be the same values.  they are dependent on user input.  In my picture, Columns M-O need to come before C-G and P-R need to come before H-L.

As you can see in my join, I have a specific order.  A rename for Year One Rate, Year Two Rate and Year Three rate put the columns down to the right after the columns H-L

Below the join marked with a red x is the join above.  The dynamic rename is an attempt to rename the generic columns with more meaningful names including dates from user input.  However, at the end, all the columns for Rate need to stay together and the columns for Circ need to stay together etc.  After all the rate and circ I'm appending spend and the same issue piles onto the other.  Any assistance would be greatly appreciated.

CharlieS · Accepted Answer

I don't have a better suggestion other than to share my method. In situations like this I'll create/rename the fields at the beginning with values that will sort and maintain order. You can even us a Field Info Tool, Record ID, then Dynamic Rename with those Record ID values. When all the data prep is finished, I'll keep that same data stream of original names and Record ID values and use another Dynamic Rename to revert the names as the very last step.

Qiu · Accepted Answer

@jjoerger 
Here is what I usually do for this situation.

The Cross Tab will force the columns by an assending order, so take the advantage by adding numbers.

if your columns are more than 10, try to make the prefix to be 2 digits.