Skip to main content
  • EN

Hello,

 

 

I have a set of lines, with the attribute 'name' coming from a first dataset and another line with the attribute 'linked_line_name' coming from a second dataset.

 

The second dataset only contains one line.

 

I'd like to select the line from the first dataset where 'name' equals 'linked_line_name'.

 

So far I've tried using the Tester transformer but can't seem to make it work as I would like to.

 

 

I created and joined a sample workspace to illustrate my problem a bit more:

 

The first dataset contains 4 lines, the second just 1.

 

I want to select the second line 'def' from the first dataset as its 'name' attribute equals 'linked_line_name' from the second dataset.

 

 

I understand why the parameters I've entered for the Tester transformer won't work but I can't figure out a way to achieve what I want. Any idea?

 

 

Thanks a lot!

Elise

You can use a featuremerger to perform this test. Send the lines to the requestor, with the single line to the supplier merging on name:linked_line_name and merging attributes only. Only lines which match will come out the merged port

As pointed out the FeatureMerger is one way to go, optonally if you prefer a more SQL apporach the InlineQuerier is another option.

The reason the tester doesnt work is because the features do not get joined (merged) and therefore the test cannot be carried out...

You can use a featuremerger to perform this test. Send the lines to the requestor, with the single line to the supplier merging on name:linked_line_name and merging attributes only. Only lines which match will come out the merged port

Thank you so much, this is exactly what I was looking for, this community seems amazing!

 

 

As pointed out the FeatureMerger is one way to go, optonally if you prefer a more SQL apporach the InlineQuerier is another option.

The reason the tester doesnt work is because the features do not get joined (merged) and therefore the test cannot be carried out...

Works perfectly too, thank you! I didn't know about this transformer, seems like I'm going to use it a lot!

 

Which option would you say is better?

 

In this article it is mentionned that the InlineQuerier can be used as a replacement for multiple FeatureMergers. What about a single FeatureMerger?

 

 

Reply


Community Stats

30,126
Posts
114,368
Replies
37,764
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.