Skip to main content
Solved

Feature Merger not merging two features

  • November 30, 2019
  • 4 replies
  • 201 views

I am trying to merge two lot of attributes but when using FeatureMerger, it is only picking up the requestor attributes and the Supplier attribute of 'issue' keeps repeating '36'.

Thanks

Bill

Best answer by takashi

You can use the FeatureMerger to collect issues from all the matched suppliers for each requestor and store them into a list attribute, then concatenate every element of the list using the ListConcatenator. Does it fit to your requirement?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

takashi
Celebrity
  • 7843 replies
  • November 30, 2019

Hi @sbarn, the FeatureMerger merges a single supplier feature for each requestor feature. If you need to duplicate each requestor feature for every matched supplier, a possible way is to create a list attribute to save all the attributes from matched features and explode it with the ListExploder after. See the Generate List option in the FeatureMerger.

However, I think the FeatureJointer could be a better solution in your case, like this.


  • Author
  • 4 replies
  • November 30, 2019

Hi @takashi thank-you for this. However I only want 624 rows returned. So I end up with columns Assessor, Assessment, Category and Issue returned for each row.


takashi
Celebrity
  • 7843 replies
  • Best Answer
  • November 30, 2019

You can use the FeatureMerger to collect issues from all the matched suppliers for each requestor and store them into a list attribute, then concatenate every element of the list using the ListConcatenator. Does it fit to your requirement?


  • Author
  • 4 replies
  • December 1, 2019

Brilliant @takashi , thank-you it worked a treat, also like your clear diagrams for me to follow.