Skip to main content
Solved

How to merge features?

  • February 19, 2018
  • 4 replies
  • 17 views

Forum|alt.badge.img

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

View original
Did this help you find an answer to your question?

4 replies

Forum|alt.badge.img

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


Forum|alt.badge.img
  • Author
  • February 19, 2018
david_whiteside wrote:

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

Hi @david_whiteside,

 

 

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

 

 


Forum|alt.badge.img
david_whiteside wrote:

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

If you have your main file going into requester and your abbreviations going into supplier. Then set up the FeatureMerger to look like the attached and try the image below.

 

 

featuremerger.jpg

 

 

Run the workspace and see if that is giving you what you need.

 

 


Forum|alt.badge.img
  • Author
  • February 20, 2018
david_whiteside wrote:
If you have your main file going into requester and your abbreviations going into supplier. Then set up the FeatureMerger to look like the attached and try the image below.

 

 

featuremerger.jpg

 

 

Run the workspace and see if that is giving you what you need.

 

 

Hi David,

 

 

Thanks for the info - I've finally managed to merge the fields using these settings:

 

 

Not sure how... but it work! ;-)

 

 

Best,

 

Ed

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings