Skip to main content
Solved

FeatureJoiner or FeatureMerger

  • March 21, 2024
  • 5 replies
  • 721 views
galigis
Enthusiast
Forum|alt.badge.img+20

Hi All,

I’m working on a workflow that requires filtering some values based on a Lookup table. I’ve initially thought using FeatureJoiner to join and filter the values but doesn’t give me the desired results as the 1:M relationship doesn’t work. I have thought about the FeatureMerger to apply the 1:M relationship but can’t get it to work.

Below a few screenshots of the tables:

Table A- Example of the table to join (by TexString)

Table B - LookUp table (by TextString - Column B)

Only the highlighted cells will be used to join  

Below is the part of the workflow to filter the value in the Table A but the join doesn’t do 1:M. There’s 193 records highlighted in yellow in the LookUp but the FeatureJoiner only joins 189 from the 1,363 records from Table A….and I’m expecting more values after the join as for example N = North Lines and S = South Lines values appears multiple times in the Table A and need to keep all of them. That’s why I think the 1:M is the one to apply here? 

Any trick to make the 1:M or maybe the join isn’t the way forward and may need to change my workflow to AttbributeFilter?

Best answer by geomancer

I'm not quite sure about what you are trying to accomplish, but possibly you need to use a FeatureMerger with 'Process Duplicate Suppliers’ activated.

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.

5 replies

becchr
Influencer
Forum|alt.badge.img+32
  • becchrInfluencer
  • Influencer
  • March 21, 2024

you are joining on the text string, right?

then there’s no join for S = South Lines as it is S = South Line (without the s at the end) in table A

there will only be a join if the textmatch is 100% (including whitespaces etc)

galigis
galigis
Enthusiast
Forum|alt.badge.img+20
  • galigisEnthusiast
  • Author
  • Enthusiast
  • March 21, 2024

Thanks @becchr - yes I’m joining on the text string. There’s S = South Lines and S = South Line in the data but screenshot only covers part of the values.

Attached some sample of the data. For example, you will see that Table A shows 4 rows with L = Line (e.g. SC001_028, SC031_019, SC031_020, SC059_002) and need to keep all of those SC values and not only join to the first (e.g. SC001)….that’s I thought 1:M relationship would be the best?

 

The idea is join Table A and Table B by Text String and retain all the possible values 

2 Attachments
geomancer
Evangelist
Forum|alt.badge.img+60
  • geomancerEvangelist
  • Evangelist
  • Best Answer
  • March 22, 2024

I'm not quite sure about what you are trying to accomplish, but possibly you need to use a FeatureMerger with 'Process Duplicate Suppliers’ activated.

galigis
becchr
Influencer
Forum|alt.badge.img+32
  • becchrInfluencer
  • Influencer
  • March 22, 2024

Thanks @becchr - yes I’m joining on the text string. There’s S = South Lines and S = South Line in the data but screenshot only covers part of the values.

Attached some sample of the data. For example, you will see that Table A shows 4 rows with L = Line (e.g. SC001_028, SC031_019, SC031_020, SC059_002) and need to keep all of those SC values and not only join to the first (e.g. SC001)….that’s I thought 1:M relationship would be the best?

 

The idea is join Table A and Table B by Text String and retain all the possible values 

not completely sure if I get it 100%, but I see 4 items L = Line in table A and 4 items L = Line in table B, and after the featurejoiner I get 16 items L = Line (so 4x4 combinations), that’s what you need right?

Workspace attached

1 Attachments
galigis
geomancer
Evangelist
Forum|alt.badge.img+60
  • geomancerEvangelist
  • Evangelist
  • March 25, 2024

I'm not quite sure about what you are trying to accomplish, but possibly you need to use a FeatureMerger with 'Process Duplicate Suppliers’ activated.

Well, that was a lucky guess 😄

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.