Ordering columns dynamically in analaytic app

wonka1234

Hi,

Is there a way to use the select tool to order columns?

Ie I have columns like

First Name

202201

Last Name

202202

202203

but want to make it

First Name

Last Name

202201

202202

202203

the issue is - i dont know which date columns will exist. It could be 202201 only, could be 202201-202212, could be aanything.

kboeckholt

@wonka1234 I've never had much luck doing it dynamically with the select tool.

My solution in the past (when I want a set of the fields to be sorted alphabetically) is to use a Transpose and Cross Tab to take advantage of the fact that the Cross Tab tool will column headers alphabetically (I've had mixed results when AMP is enabled). 

Input:

Transpose:

Cross Tab:

Output:

Sort Fields_KB.yxmd