Skip to main content
  • EN

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 ?

Which attribute are you merging on?

Which attribute are you merging on?

Joining on ID

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

 

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

If only Table1 contains geometry you can use a FeatureJoiner with a Full Join

Reply


Community Stats

30,190
Posts
114,572
Replies
37,851
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.