Skip to main content
Solved

Merge a lookup feature into a list of data features

  • April 24, 2024
  • 2 replies
  • 34 views

missp29
Contributor
Forum|alt.badge.img+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

Best answer by DanAtSafe

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.

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.

2 replies

DanAtSafe
Safer
Forum|alt.badge.img+21
  • Safer
  • Best Answer
  • April 24, 2024

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.


missp29
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • April 24, 2024

Hi DanSafe,

 

Thank you very much for your quick response. 

It works perfect!!!

 

Thanks,

-John