Skip to main content

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

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.


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.


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?


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


Reply