Maybe I missed this in the configuration somewhere, but is there a way to sort the column headers (alphabetically) resulting from the Cross Tab tool?
Upstream of the Cross Tab, I tried sorting the rows that would become the Cross Tab column headers (ie: Item Type), but this didn't help.
Thanks!
Solved! Go to Solution.
@flying008 ya, it become one more thing to be aware in future development.
further explain on the AMP (your question 1), when i turn on AMP, it works fine for output 2, but if i turn off AMP, output 1 and 2 are disarray...
in further testing, if I duplicate result in transpose (copy and paste in text input and start run from here), the result is fine...
don't know what to do to avoid this...