Sort Dynamic fileds alphabetically in a analytical APP

[sanchit]

Hi Everyone,

I have some columns named catergory, property1,property2, umbrella1,umbrella 2. and property and umbrella header names keep changing based on year,

I run this for every year taking year as a input from interface tool, I used select tool and try to sort by alphabets it works fine for only one year and remaining years it gets messed up 

like Eg- Categorty then property 1 , umbrella 1, property2,property3,propert4,umbrella 2,umbrella3 and so on.

what i need :

I just want them to be together Eg- Categorty then property 1,2,3,4,5 and umbrella 1,2,3,4,5

[binu_acs]

@sanchit Can you provide sample input data and expected output?

[sanchit]

please find the attached files

[sanchit]

@binu_acs 

[SPetrie · Accepted solution]

There is a field sort in the CReW macro pack.

It would do what you are wanting.

[binu_acs]

@sanchit Another way of doing this by Transposing the values , sort and cross tab

[sanchit]

Thank you for this, even if you dont want to use a macro from crew you can just copy the tools used in them and this is effective if you have dynamic fields whose names keeps changing as well.