Solved

Merge a lookup feature into a list of data features

  • 24 April 2024
  • 2 replies
  • 15 views

Badge +1

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

icon

Best answer by DanAtSafe 24 April 2024, 21:51

View original

2 replies

Userlevel 2
Badge +11

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.

Badge +1

Hi DanSafe,

 

Thank you very much for your quick response. 

It works perfect!!!

 

Thanks,

-John

Reply