Crosstab Column Order

knnwndlm

Hi SME,

I have a workflow that I plan to convert into a macro, but I'm struggling with getting the header columns to tie to the data correctly. The Name field in the Text Input tool has correct header name that I want except in descending order with the multiple years shown last. In other words, I want the header to show the most recent year first and the total year column last, so if I have 2022, 2023, 2024, and 2024-22, I want to see 2024, 2023, 2022, and then 2024-22 embedded in the header name. This is so that I can tie the data in the correct header name. The workflow below doesn't work because the data and the headed have ascending and descending order, respectively. Could you please help me understand how to fix this so that the header aligns with the data?

Thanks,

kwl

Crosstab Column Order.yxzp

Qiu

@knnwndlm 
The CrossTab tool will reorder the column in an accending order so we can utilize this feature by adding some prefix the columns so they can fall into the order we need then remove those prefixes afterwards.

Crosstab Column Order-r1.yxzp