Sort Dynamic fileds alphabetically in a analytical APP

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

Transformation

Data Investigation

Accepted answers

SPetrie

There is a field sort in the CReW macro pack.

It would do what you are wanting.

All comments

binu_acs

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

sanchit

please find the attached files

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

Sort_25_04.yxmd

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.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335