Hello Everyone-
I need some help in sorting dynamic data along with retaining certain column positions. For example in the snippet shown below :
With the addition of a new month (11 in this case) , the latest month (11) goes to very end after the "Tab" column instead of after column 10. I cam across some solution where in some authors used the FieldInfo tool although it doesn't address the point where certain columns has to be at fixed location in other words in the snippet shown below the "Total","Average", "Q1","Q2","Q3","Q4","Tab" has to come after columns 1-11.
Below snippet shows what is required.
Logic i am using- in order to retain certain fixed positions of "Total","Average", "Q1","Q2","Q3","Q4","Tab",I am assigning a number value to them like "Total"=14, "Average" = 15, "Q1"=16, etc. and then adding a sort tool to sort the field in ascending order before passing it through the transpose tool- the logic works fine past transpose tool however as soon as it goes to Table tool the column structure breaks and the new column (11 in this case) is pushed to the very end.
Following snippet shows the logic i am using in my WF.
Will really appreciate any help.
Thank you very much.
MD
