I am having issues with featuremerger mixing up ID numbers.
I am joining two TAB files, address and propertyparcel. both tables hold a property ID on which I am merging.
I want the resulting address table (requestor) to hold the parcel id.
The issue is that after transformation the attributes are mixed up. the parcel id is populated with the property id and vice versa. Even weirder is that this is not consistent. it seems totally random as far as I can tell. (of over 25,000 records 11,000 get mixed up!)
All atribute fields have unique names before merging (I have put in attribute renamers before the merge).
any tips will be greatly apreciated!!