Skip to main content
Question

Can I retain unmatched features using Joiner 1:M

  • March 10, 2014
  • 3 replies
  • 11 views
inframan
Contributor
Forum|alt.badge.img
FME newbie here,

 

 

I'm joining taxroll (dbf) data with (shp) parcel data. I'm creating stacked parcels where the parcel number is repeated in the taxroll using a 1 to many join. It works great but I am losing the parcels with a non matching or null parcel numbers. Is there a way to retain the 1:0 polygons and also create 1:M polygons at the same time?

 

 

thanks
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.

3 replies

takashi
Celebrity
  • takashiCelebrity
  • March 10, 2014
Hi,

 

 

The Joiner (1 : M) doesn't retain unmatched features. Consider using the FeatureMerger (Process Duplicate Support: Yes) + ListExploder, or the InlineQuerier with appropriate SQL query.

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
takashi
Celebrity
  • takashiCelebrity
  • March 11, 2014
for example,

 

FeatureMerger + ListExploder:

 

 

 

InlineQuerier:

 

 

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
inframan
Contributor
Forum|alt.badge.img
  • inframanContributor
  • Author
  • Contributor
  • March 13, 2014
works great, thanks

Community Stats

32,207
Posts
122,305
Replies
39,891
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.