Skip to main content
  • EN

Hello,

 

I am struggling with an issue within my workbench. It is a bit difficult to explain, so I hope my explanation is understandable.

 

I got stuck at this transformer:

 

The failed output port is similar to this format:

 

The passed output port is similar to this format:

 

What I want to accomplish is the following table:

So I want to test the outcome of the failed output port based on the fact if a value in the 'Number' column corresponds to a value in the 'Number' column of the passed output port. And if a row meets this requirement I want to join it with the rows of the passed output port.

Can anyone explain to me which transformer(s) I should use to accomplish this?

 

Thanks in advance!

Eva

You can use a FeatureMerger or FeatureJoiner for this. Have it join on the fields Number and Subnumber and that should do the trick.

You can use a FeatureMerger or FeatureJoiner for this. Have it join on the fields Number and Subnumber and that should do the trick.

Hi @redgeographics,

 

Thanks for the quick reply.

But I don't get the result I want with the FeatureJoiner. If I join on both the Number en Subnumber fields nothing happens:

And if I join only on the Number column I get this result:

 

 

Do I need the use different settings?

 

But I also thought that the feature joiner is meant to join different columns (attributes) together, right? And not to join rows based on a condition?

I'd suggest using the feature merger instead, this will allow you to control where both sides of the join have the same attribute names

Based on your example data, you send the features that require correction straight to the output and also use them as the supplier with the failed features as the requestor. Make sure conflict resolution is set to Use Requestor. This gives you the 6 features. You may need to sort afterwards depending on requirements

I'd suggest using the feature merger instead, this will allow you to control where both sides of the join have the same attribute names

Based on your example data, you send the features that require correction straight to the output and also use them as the supplier with the failed features as the requestor. Make sure conflict resolution is set to Use Requestor. This gives you the 6 features. You may need to sort afterwards depending on requirements

Thank you @ebygomm! With a sorter at the end I indeed get the required result.

Reply


Community Stats

30,179
Posts
114,557
Replies
37,844
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.