Force field scheme in data to match template (names and order of fields)

[nweil]

This is one of those things that sounds so simple to me but I can't work it out.

I have a template file with a set of field names. The set of fields and their order are both important, so I want to force my data to conform to that. Meaning I want to:

1. Deselect any fields that don't belong

2. Add any fields that do belong

3. Sort all of the fields into the correct order

Really, the first two are easy (although maybe there's a simpler solution than mine for #1) but I can't figure out number three. I know that the union tool makes a decision about the order of field names, but I've been playing with it and I can't figure out what its rules are.

[PhilipMannering]

Add a Select Tool before your output.

- Make your selection

- If you reorder the columns, they will stick to that order

- If you uncheck "Unknown" then no new fields will be added.