Skip to main content

Hi All,

 

I have a list of data features like this

Name   Phone Number   City

Smith   123-456-7890     New York

Bob      987-654-3210     Huston

In addition, I have a single lookup feature like this

Company   Id

xyz             123

I would like to merge the lookup feature into the list of data features like this

Name   Phone Number   City             Company   Id

Smith   123-456-7890     New York    xyz             123

Bob      987-654-3210     Huston       xyz              123

 

I thought I can use transformers FeatureMerger or FeatureJoiner to do this. However, since I don’t have a common attribute to compare, neither of them works. 

Can anyone help me on this issue here?

 

Thanks,

-John

Hi John, Just set the Requestor and Supplier in the FeatureMerger to 1, or “1” , or any other identical value.  This should merge all attributes from the Supplier (Company & Id) onto the Requestor features.


Hi DanSafe,

 

Thank you very much for your quick response. 

It works perfect!!!

 

Thanks,

-John


Reply