Skip to main content
Question

FeatureMerger UsedSupplier

  • July 21, 2020
  • 5 replies
  • 18 views

sunsilk11
Contributor
Forum|alt.badge.img+6

Hi I am using FeatureMerger to merge attributes and geometry as follows

Table1:

ID1 Value1

ID1 Value2

ID1 Value3

 

Table2:

ID1: Code1

ID2: Code2

ID3:Code3

 

I would like to end up with 9 records in the output

Expected result:

ID1 Value1 Code1

ID1 Value1 Code2

ID2 Value1 Code3

ID1 Value2 Code1

ID1 Value2 Code2

ID2 Value2 Code3

ID1 Value3 Code1

ID1 Value3 Code2

ID2 Value3 Code3

 

I have tried various options in FeatureMerger, but I am still missing records in the output

This seems to be in the Used Supplier port.

 

Any suggestions ?

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

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • July 21, 2020

Which attribute are you merging on?


sunsilk11
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • 66 replies
  • July 21, 2020

Which attribute are you merging on?

Joining on ID


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • July 21, 2020

Joining on ID

I don't see how you would get the 9 records you list as output, where would this value come from

ID2 Value1 Code3

 


sunsilk11
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • 66 replies
  • July 21, 2020

I don't see how you would get the 9 records you list as output, where would this value come from

ID2 Value1 Code3

 

Sorry you are right. Typo

Table2 is rather:

ID1: Code1

ID1: Code2

ID1:Code3

 

 

ID1 Value1 Code1

ID1 Value1 Code2

ID1 Value1 Code3

ID1 Value2 Code1

ID1 Value2 Code2

ID1 Value2 Code3

ID1 Value3 Code1

ID1 Value3 Code2

ID1 Value3 Code3


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • July 21, 2020
If only Table1 contains geometry you can use a FeatureJoiner with a Full Join