Hi all,
I'm having issues merging two Excel files - I have tried FeatureMerger but I'm not getting any results.
I have a "main file" that contains a feature "POI_SHORT_NAME".
I also have an "abbreviations" file containing the same feature "POI_SHORT_NAME"
What I'm trying to do:
When the postalcodes in both files match then the POI_SHORT_NAME from the abbreviations file should be written to the main file.
Cheers,
Ed
Best answer by david_whiteside
Because you have columns which are the same name, it will cause a conflict resolution.
You can choose what to do here by expanding the Attribute Accumulation section in FeatureMerger
In the event of a conflict, you can use Requester, supplier or prefix supplier.
Alternatively, you can rename the attibute in one of your files before it reaches the FeatureMerger
Because you have columns which are the same name, it will cause a conflict resolution.
You can choose what to do here by expanding the Attribute Accumulation section in FeatureMerger
In the event of a conflict, you can use Requester, supplier or prefix supplier.
Alternatively, you can rename the attibute in one of your files before it reaches the FeatureMerger
Because you have columns which are the same name, it will cause a conflict resolution.
You can choose what to do here by expanding the Attribute Accumulation section in FeatureMerger
In the event of a conflict, you can use Requester, supplier or prefix supplier.
Alternatively, you can rename the attibute in one of your files before it reaches the FeatureMerger
Can you perhaps show me what the FeatureMerger is supposed to look like?
I have no idea how I should set up the Requestor / Supplier.
Cheers,
Ed
Because you have columns which are the same name, it will cause a conflict resolution.
You can choose what to do here by expanding the Attribute Accumulation section in FeatureMerger
In the event of a conflict, you can use Requester, supplier or prefix supplier.
Alternatively, you can rename the attibute in one of your files before it reaches the FeatureMerger
featuremerger.jpg
Run the workspace and see if that is giving you what you need.
featuremerger.jpg
Run the workspace and see if that is giving you what you need.
Thanks for the info - I've finally managed to merge the fields using these settings:
Not sure how... but it work! ;-)
Best,
Ed
