Using reverse field mapping in a macro.

Question

With reverse field mapping, is there any way to ensure that the order of the fields coming into the macro and going out of the macro are exactly the same ?

At the moment, if my macro changes one field (eg B)  and the fields are input in this order: A, B, C the output is A, C, B.

Is there any way to ensure that if the incoming fields are A, B, C then the outgoing fields are also A, B, C ?

dreldrel · Answer

You can use the select tool to reorder your columns right before Marco output tool, which can ensure you get the desired column order

OTrieger · Answer

@cmcclellan

It is hard to tell what is going wrong as nothing is attached. However when I need reverse field mapping in a particular order what I will do is using the RecordID as the headers, so I will use a Dynamic Renaming tool before that the data is going into the macro and then Rename the fields at the end, returning them to the original names. Now if something will go wrong it is very easy to track it and fix it.