DataManager: Sorting 1000s of Fields/Columns alphabetically?

davedunckley · February 6, 2013 11:13AM

Is there any way of making the field names in the Field Organiser block box be sort in alphabetical order?

paola · February 6, 2013 11:18AM

Sure - next to each field there is a little hand that you can click on and drag the field to a desired place (creating alphabetical order).

davedunckley · February 6, 2013 11:28AM

Thanks, but I wondered if there is an automated way to do this, because I have 1000s of fields. Would take weeks to do it that way.

Dave

paola · February 6, 2013 12:16PM

Use Omniscope to do the whole thing, using DataManager workspace operations blocks Transpose and Sort. See the attached file.

davedunckley · February 7, 2013 8:20AM

thanks