community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Sort Field Names Tool

In my environment, creating tables with fields in a particular order is a requirement.

The Select tool (and others) let me manually change sort orders. The Select tool will also allow me to sort on Field Name in Ascending or Descending order.

I can add a sort order prefix to my input data with the Dynamic Rename tool, connect a Select tool and then go into the Select tool properties to sort by Field Name. But this requires that I first run the module so that the Select tool knows what the incoming fields are called, then set up the Select tool properties, and then rerun the module. If I change the prefixes or the list of incoming variables, the Select tool has to be reconfigured.

It would be really nice if there was a Field Sort tool that only had Ascending or Descending as properties that would 'dynamically' do what the Sort on Field Name option in the Select tool does.
3 Comments
Alteryx
Alteryx
Hi Tom,

Do you mean something like this:

http://downloads.chaosreignswithin.com/community/FieldSortMacroExample.yxzp

Cheers
Adam
Alteryx Partner
Adam,
That's exactly what I was looking for!
I don't know why I didn't think of it myself...great use of the Dynamic Rename and Union tools.
Thanks,
Tom.
Alteryx
Alteryx

I have now released a version of this macro as part of my Blog Macro pack here:

http://www.chaosreignswithin.com/2014/09/blog-macro-pack-2014-q3-release.html

and so have removed the download for the version above.

Adam